SQL

left outer join max

code2 2008. 9. 16. 12:29
SELECT g.* , y.* FROM usr_group g
LEFT OUTER JOIN dat_year y
ON y.y_group_no = g.g_no  
WHERE y.y_no = ( SELECT max(y_no) FROM dat_year WHERE y_group_no=g.g_no )
order by g.g_no asc