cbm3384 Posted February 21, 2011 Share Posted February 21, 2011 How do I get this query to return a single row, of no significance, if the second subquery equals zero? (And still return what it does now if the second subquery > 0) select tasks.task_id from tasks, stages where tasks.job_id=1111 and tasks.stage_id=stages.stage_id and stages.stage_num=( and (select count(task_id) from tasks where start_date is not null and job_id=1111)=(select count(task_id) from tasks where job_id=1111) Thanks, Chris Quote Link to comment https://forums.phpfreaks.com/topic/228432-subquery-questions/ Share on other sites More sharing options...
fenway Posted February 23, 2011 Share Posted February 23, 2011 Why not use EXISTS? Quote Link to comment https://forums.phpfreaks.com/topic/228432-subquery-questions/#findComment-1178636 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.