Hi guys,
The below SQL statement returns a requirement name and the SUM of the number of number of tests run in each test related to that requirement for Release 10. To filter on a particular release, I need to convert this statement into an equivalent INNER JOIN because 'Tests_run' isn't the only attribute for a test I need to return.
Please help! Here's the current SQL subquery statement.
SELECT Requirement.Name
(SELECT SUM(Test_Status.Run)
FROM Test_Status, Test_Lookup, Test_Script
WHERE Test_Lookup.Test=Test_Scripts.ID
AND Test_Status.Test=Test_Script.Test_Script_Test
AND Test_Lookup.Requirement=Requirement.ID
AND Test_Status.Release=10) AS Tests_Run,
FROM Requirement
Thanks very much.
The below SQL statement returns a requirement name and the SUM of the number of number of tests run in each test related to that requirement for Release 10. To filter on a particular release, I need to convert this statement into an equivalent INNER JOIN because 'Tests_run' isn't the only attribute for a test I need to return.
Please help! Here's the current SQL subquery statement.
SELECT Requirement.Name
(SELECT SUM(Test_Status.Run)
FROM Test_Status, Test_Lookup, Test_Script
WHERE Test_Lookup.Test=Test_Scripts.ID
AND Test_Status.Test=Test_Script.Test_Script_Test
AND Test_Lookup.Requirement=Requirement.ID
AND Test_Status.Release=10) AS Tests_Run,
FROM Requirement
Thanks very much.