Can I specify specific criteria with an outer join?

[jenabl01]

I have the following:

SELECT A.LOB, A.INVOICE, A.LINE, B.BI_ID, B.BI_TXT
FROM INV_LINE A, LINE_SB B
WHERE A.LOB = B.LOB (+)
AND A.INVOICE = B.INVOICE (+)
AND A.LINE = B.LINE (+)

I want to be able to specify a specific BI_ID (for those that have one), but lose the lines that don't have anything on the LINE_SB table.

Is this possible?

 

[tlbroadbent]

Add the following to the criteria.

AND (B.BI_ID = <criteria> Or B.LOB Is Null) Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[jenabl01]

I just had to add the following:

b.invoice is null
b.line is null

and it works like a charm!

Thank you so much!!!