Skip to Content
0
Former Member
Oct 09, 2008 at 09:14 PM

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

31 Views

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

TB1 left outer join TB2(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