Help with Join [message #373430] |
Mon, 16 April 2001 21:42 |
arun
Messages: 67 Registered: January 2000
|
Member |
|
|
Can anyone pl help me with this query?
3 Tables: T1 , T2 and T3 with T1pk, T2pk & t3pk primary key respectively
Records in T2 and T3 have the T1pk column (foreign key)
I would like a query which displays
T1pk, T2pk, null
T1pk, null, t3pk
assuming that T1, T2 and T3 have all one record each.
Example:
T1
a
T2
x,a
T3
y,a
The query should return
x,a,null
y,null,a
TIA,
Arun
|
|
|
Re: Help with Join [message #373438 is a reply to message #373430] |
Tue, 17 April 2001 07:40 |
Koresh
Messages: 4 Registered: April 1999
|
Junior Member |
|
|
Hi.
Hint: Try using outer join - i.e.
add a (+) after a foreign key wich could be NULL
in query.
Hope it will help.
Regards.
|
|
|