Select statement within the select statment

[petev]

Below is a statement that give me the results as follows:
--------------------
Tester | Total_Target_Cycle
tester1 | 5
tester2 | 6

I am trying to figure out how i can get total_defects column with only open defects only and percent changet between the target cycle and total defects.

------------------------------------------------------
Tester | Total_Target_Cycle | Total_Defects| % Change
------------------------------------------------------
tester1 | 5
tester2 | 6


HOW TO COMBINE THE TWO STATEMENTS BELOW. THANKS

select BG_detected_by Tester,COUNT(*)Total_Target_Cycle
From Bug
where BG_STATUS = 'Open'and BG_TARGET_RCYC IS NOT NULL
GROUP by BG_DETECTED_BY, BG_STATUS,BG_TARGET_RCYC

select bg_detected_by tester, count(*) Total
from bug
where bg_status = 'Open'
group by bg_status,bg_detected_by

[amitpatel66]

Try this:

SELECT tester,total_target_cycle,(SELECT COUNT(*) FROM bug where bg_detected_by = x.tester AND bg_status = 'Open') total FROM
(select BG_detected_by Tester,COUNT(*)Total_Target_Cycle
From Bug
where BG_STATUS = 'Open'and BG_TARGET_RCYC IS NOT NULL
GROUP by BG_DETECTED_BY, BG_STATUS,BG_TARGET_RCYC)