Sql right join

This article is tagged with: Sql right join and mysql

sql right join

SELECT *
FROM table_1
RIGHT JOIN table_2
ON table_1.common_field = table_2.common_field;

right join

RIGHT JOIN: Matching part from both
table and unmatching part from right table.

left join sql

SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;

This article is tagged with: Sql right join and mysql