inner join: as long as there is a match between the columns in both tables, it return rows from the both tables. it likes the maths terms:intersection
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name=table2.column_name;
left outer join;return all rows from the left table ,with the matching rows in the right table.the result is null in the right side when there is no match
SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name=table2.column_name;
right outer join:return all rows from the right table with the matching rows in the left side ,the result is null in the left side when there is no match
SELECT column_name(s)
FROM table1
RIGHT JOIN table2
ON table1.column_name=table2.column_name;SELECT column_name(s)
FROM table1
RIGHT JOIN table2
ON table1.column_name=table2.column_name;