Home » SQL & PL/SQL » SQL & PL/SQL » SELECT STATEMENT
SELECT STATEMENT [message #20005] Wed, 24 April 2002 01:10 Go to next message
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 Go to previous messageGo to next message
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
Re: SELECT STATEMENT [message #20009 is a reply to message #20005] Wed, 24 April 2002 02:03 Go to previous message
Karri
Messages: 33
Registered: May 2001
Member
It works, thanks a lot!

-Karri
Previous Topic: Error handling and package dependencies
Next Topic: sql query
Goto Forum:
  


Current Time: Thu Mar 28 18:16:48 CDT 2024