SQL Correlated Sub Query

SQL Correlated Sub Query Unique construct Equivalent

 

select T.course_id 
from course as T 
left join section as R where T.course_id = R.course_id and R.year = 2009
group by T.course_id
having count(R.course_id) <= 1

LEAVE A REPLY

Please enter your comment!
Please enter your name here