Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Thank you so much, that's very helpful.
| | | ---------------Original Message---------------
From: Sean Jia
Sent: Tuesday, September 20, 2011 2:42 AM
Subject: Query with Left Outer Join
Hi all,
I want to create a query to display vendor, bank and bank name. Three tables are involved lfb1, lfbk, bnka.
But during the table join, I can place only one outer join between 'lfb1 and lfbk' or 'lfbk and bnka', either way can't display those vendors without bank information in master data.
vendor:A bank:1 bankname:aaa
vendor:C bank:2 bankname:bbb
What can I do to make all vendors displayed?
vendor:A bank:1 bankname:aaa
vendor:B bank: bankname:
vendor:C bank:2 bankname:bbb
Thank you. |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Popular White Papers
In the Spotlight   _.____.__ |
