SELECT p.PlanId, p.Name, s.PlanId, s.SuiteId, s.Title, se.SuiteId, se.TestCaseId, w.ID, w.Title, w.AreaID FROM dbo.tbl_Plan p
JOIN dbo.tbl_Suite s
ON s.PlanId = p.PlanId
JOIN dbo.tbl_SuiteEntry se
ON se.SuiteId = s.SuiteId
JOIN dbo.WorkItemsAre w
ON w.ID = se.TestCaseId
WHERE p.Name = 'xxxx'
AND se.ChildSuiteId = 0
Advertisements