kirantcs1

 Profile Answers by kirantcs1 

• Dec 21st, 2009

 

If you have Table1 and Table2 and you want all the records from table1 and the matching records from table2. Then we put the out join on table1 which is called left outer join. if we put the outer join on table2 then it would be called right outer join.

1) Select table 1 and right click on it select the option Join.
2) select the table2 in the window and select the common column in both tables and set the cardinality (relation of the tables)
3) you will have outer join check boxes below the table1 column list and below the table2 column list
4) if you select the table1 outer join check box that would be left outer join which results all the records of table1 along with matching records from table2
5) if you select the table2 outer join check box that would be right outer join which results all the records of table2 along with matching records from table1.

Cheers..