... it will work:
SELECT DISTINCT T1.USER,
DECODE(T2.authCountryid, 19, '19', NULL)
FROM T1, T2
WHERE
T1.USER = T2.USER AND
(T1.USER, T2.authCountryid ) IN
(SELECT USER, MAX(authCountryid )
FROM T2
GROUP BY USER)
Enjoy!
|
Results 1 to 6 of 6
Thread: Urgent! Outer Join doesn't work.Threaded View
|
Click Here to Expand Forum to Full Width |