what is Left Join and Right Join

[PPCC]

could any body describe what is Left Join and Right Join ?

thanks for reply.....

[Pasvorto]

There are two outer joins: LEFT JOIN and RIGHT JOIN. The "direction" of the join refers to the relative position of the table names in the FROM clause of the SQL statement. A LEFT JOIN returns a record from the table on the left side of the FROM clause, whether or not a matching record exists on the right side. A RIGHT JOIN returns a record from the table on the right side of the FROM clause, whether or not a matching record exists on the left side. These two FROM clauses, therefore, have identical results:

FROM Customers LEFT JOIN Invoices ON Customers.[Customer Number] = Invoices.[Customer Number]

FROM Invoices RIGHT JOIN Customers ON Invoices.[Customer Number] = Customers.[Customer Number]