If you just mentioned JOIN in query by default it will be considered as a INNER JOIN.

Left join

e.g

SELECT column_name(s) FROM table_name1 #(Left table) LEFT JOIN table_name2 #(Right table) ON table_name1.column_name=table_name2.column_name 

Left join will take all the elements from Left table and only matching records from the Right table as Follows.

Hope this helps.

If you just mentioned JOIN in query by default it will be considered as a INNER JOIN.

Left join:Left join will take all the elements from Left table and only matching records from the Right table as Follows. example:

SELECT column_name(s) FROM table_name1 #(Left table) LEFT JOIN table_name2 #(Right table) ON table_name1.column_name=table_name2.column_name 

Hope this helps.