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.Nam e
(SELECT SUM(Test_Status .Run)
FROM Test_Status, Test_Lookup, Test_Script
WHERE Test_Lookup.Tes t=Test_Scripts. ID
AND Test_Status.Tes t=Test_Script.T est_Script_Test
AND Test_Lookup.Req uirement=Requir ement.ID
AND Test_Status.Rel ease=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.Nam e
(SELECT SUM(Test_Status .Run)
FROM Test_Status, Test_Lookup, Test_Script
WHERE Test_Lookup.Tes t=Test_Scripts. ID
AND Test_Status.Tes t=Test_Script.T est_Script_Test
AND Test_Lookup.Req uirement=Requir ement.ID
AND Test_Status.Rel ease=10) AS Tests_Run,
FROM Requirement
Thanks very much.