Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can I specify specific criteria with an outer join?
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!!!- jenabl01
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Can I specify specific criteria with an outer join?
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...- jenabl01
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
How do I return data from 2 different rows on the same row?
When I run the following, I get two rows of data for the same unit, invoice, line_num that has two spcl_bi_id and spcl_bi_txt. SELECT A.UNIT, A.INVOICE, A.LINE_NUM, B.SPCL_BI_ID, B.SPCL_BI_TXT FROM BI_LINE A, BI_LINE_SB B WHERE A.UNIT = B.UNIT AND A.INVOICE = B.INVOICE AND...- jenabl01
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
