cancel
Showing results for 
Search instead for 
Did you mean: 

Left outer join------which table should you click

Former Member
0 Kudos

Hello Freinds,

I am trying to create a left outer join bet two tables TB1 and TB2. I want all the rows of TB1 and only the corresponding from TB2.

In the Infoset design screen the table positions are as below

TB1left outer joinTB2(TB1 is greyed out and TB1 is white in background).I clicked on TB2 and selected the left outer join option.

Does this mean that left outer join is accomplished?

Thanks a lot

-Smmi

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi........

Check this........

http://help.sap.com/saphelp_nw04s/helpdata/en/67/7e4b3eaf72561ee10000000a114084/frameset.htm

This will help you to clear your doubts.......

Regards,

Debjani.......

Former Member
0 Kudos

Hi ,

Right click & select left outer join , then connect the fields from Tables on which u want the data to merge.

Now select the fields from the Tables (check all fields in TB1 & only those required fields in TB2)

reg

ramy

Former Member
0 Kudos

yes it should. link the fileds u require and right click on the link and select left outer join.