Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to join multiple tables with lfet outer join in SQ02

Former Member
0 Kudos
1,273

Hi,Guys

I want to show all customer master data and check the customer's Bank informations.

Because some customer not maintain the bank information,So I have to use Left outer join.

I use SQ02 insert three tables KNA1 KNBK BNKA,the system default join type is inner join with

the three tables,I want change the link them like this:

KNA1-KUNNR left outer join KNBK-KUNNR and KNBK-BANKL left out join BNKA-BANKL,

The system only permit KNA1 left outer join KNBK,when I change the Link to Left outer join with

KNBK and BNKA, the system show this massage "Illegal left-outer-join chain between tabkes KNA1,KNBK and BNKA

"

Is that The Query not permit multiple table left outer join ?

How to slove my problem?Is there any other solution to meet my requirement?

Thanks,

yongqian wang

Edited by: yongqian wang on Oct 22, 2010 1:17 PM

2 REPLIES 2

brad_bohn
Active Contributor
0 Kudos
189

Yes, that's correct - you can't left outer join three tables in a query or quickview. However, do you really need a left outer join between KNBK and BNKA? Shouldn't that be an inner join anyway?

Former Member
0 Kudos
189

Because some customer not maintain the bank information,But I want show all the customer's bank informations,So I want to use Query to meet my requirement.

How to slove my problem?

Thanks,

yongqian wang