What is the difference between left join and right join?

Answer 1

left join means compare values and if left join is extra value which is same it is considered in the output but right side value is not in left join

and it's vice-versa for the result of the right join

Answer 2

Left Join - Values from Left table will be joined with matching records in the Right table
Right Join - Values from Right table will be joined with matching records in the Left table

Answer 3

http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

this is a visualization of the joins the article is good to read as well but the visual is what you are after here

Answer 4

hello