What is left join, right join? (learn all joins)

Interview Candidate
Aug 28th, 2004
1
2303

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

Satish Kumar

Jun 6th, 2007

Suppose if you have table-A (Left Table) & Table-B(Right Table).
Left Join: Merging the values of Table-A & Table-B of common fields between them & also other values of Left Table(Table-A).
Right Join:Merging the values of Table-A & Table-B of common fields between them & also other values of Right Table(Table-B).