on 10-09-2008 10:14 PM
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
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.......
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes it should. link the fileds u require and right click on the link and select left outer join.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.