Outer Joins [message #37629] |
Mon, 18 February 2002 04:59 |
Frederik
Messages: 8 Registered: December 2001
|
Junior Member |
|
|
Hi!!
Iīm trying to make a select joining two tables, but I just canīt seem to make it right. It is:
SELECT R.EMPID, L.DAY, R.ENT, R.EXT, L.QTY
FROM TAREGIS R, TALIQD L
WHERE L.EMPID (+) = R.EMPID AND
L.DAY (+) = TRUNC(R.ENT) AND
L.LIQID = wLIQID
TALIQD has more records per day than TAREGIS, and several LIQID's; the thing is, if I take out the "...AND L.LIQID = wLIQID..." filter the outer joins comes out OK, but when I want to identify a single LIQID it doesnīt work (it doesnīt bring NULL when the record from TALIQD is not there, it just doesnīt show the records from TAREGIS).
Maybe, itīs just sth kinda stupid, but I canīt fiugre it out. H E L P !
Thanx in adv, Fred 8)
|
|
|
Re: Outer Joins [message #37630 is a reply to message #37629] |
Mon, 18 February 2002 05:12 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
try this
SELECT R.EMPID, L.DAY, R.ENT, R.EXT, L.QTY
FROM TAREGIS R, TALIQD L
WHERE L.EMPID (+) = R.EMPID AND
L.DAY (+) = TRUNC(R.ENT) AND
L.LIQID(+) = wLIQID
|
|
|
|
|
Re: Outer Joins [message #37639 is a reply to message #37629] |
Mon, 18 February 2002 08:42 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
I think u r trying in wrong way
you have to outer join table which have less number of records
SELECT R.EMPID, L.DAY, R.ENT, R.EXT, L.QTY
FROM TAREGIS R, TALIQD L
WHERE L.EMPID = R.EMPID(+) AND
L.DAY = TRUNC(R.ENT)(+) AND
L.LIQID = wLIQID
|
|
|
|
Re: Outer Joins [message #37653 is a reply to message #37639] |
Tue, 19 February 2002 04:36 |
Frederik
Messages: 8 Registered: December 2001
|
Junior Member |
|
|
Hi!
Iīve tried that, but I think itīs kinda more complicated... I NEED some records from the other table, TAREGIS. Thx anyway.
CU, Fred :)
|
|
|