Left Right Table

[mehrdadc48]

In a join which table is said Left, which one right? It depends on List in select or order in On or ...

Best wishes

[Rupesh Kumar Swami]

table1 left join table2 on table1.id=table2.id here table1 is left table whereas table2 is right. Query return all record from table1 plus matches record from table2 table1 right join table2 on table1.id=table2.id here table1 is left table whereas table2 is right. Query return all record from table2 plus matches record from table1 hope this clear your confusion

Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

[J4amieC]

The left one is the one on the left of the join and the right one is the one on the right of the join. That is in Left-to-Right text. I cant imagine how messed up queries would look in Hebrew (RtL)

[Muhammad Shahid Farooq]

See the following example: Select table1.*, table2.* From table1 join table2 on table1.Id = table2.Id In the above example table1 is considered left and table2 is considered right.