Left outer join------which table should you click
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
left 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