SELECT STATEMENT [message #20005] |
Wed, 24 April 2002 01:10 |
Karri
Messages: 33 Registered: May 2001
|
Member |
|
|
Hi,
I need help for this:
TAB1 always include user_id
TAB2 some times include user_id
Now Í must do that kind of SELECT statement
that every time when TAB1 include USER_ID, statement
returns a.USER_ID and B.user_ID
SELECT a.USER_ID, b.USER_ID
FROM TAB1 a, TAB2 b
WHERE .......
Result should be like:
a.USER_ID_____ b.USER_ID
1 1
2
3 3
I try NVL-funktion, but it dosn't work..
BR Karri
|
|
|
Re: SELECT STATEMENT [message #20007 is a reply to message #20005] |
Wed, 24 April 2002 01:51 |
mF
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
How about:
SELECT a.USER_ID, b.USER_ID
FROM TAB1 a, TAB2 b
WHERE a.USER_ID = b.USER_ID (+)
This includes all not null rows from a, and if there is no according id in b, the value shown for b.USER_ID is NULL (outer join).
Cheers,
mF
|
|
|
|