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
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