select task.task_num, subtask.stsubtask ; from task, subtask ; where task.task_num = subtask.sttask and ; task.tstatus = "C" and ; task.task_num > "20000000" ; order by task_num, stsubtask ; into cursor temp1This one counts the defects
select temp1.task_num, temp1.stsubtask, count(defect.defect_num) as defect_cnt ; from temp1 left outer join defect ; on temp1.task_num = defect.task and ; temp1.stsubtask = defect.subtask ; order by task_num, stsubtask ; group by task_num, stsubtask ; into cursor temp2Is there a way to combine them into one query?