Re: Oracle Left Outer Join problem - first occurance of a match

I got an email from z1hou1_at_gmail.com and this works:

SELECT f.id, f.first, l.second
FROM first_names f, (SELECT min(l1.id),l1.last_name FROM last_names l1
group by l1.last_name ) l
WHERE f.id = l."MIN(l1.id)"
UNION ALL
SELECT f.id, f.first,NULL
FROM first_names f
WHERE f.id NOT IN (SELECT l.id FROM last_names l)

Thanks!! Received on Thu Oct 30 2008 - 14:45:47 CDT