Database Join and Type of Join
Joins standard include the following:
Natural joins:
NATURAL JOIN clause
USING clause
ON clause
Outer joins:
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
Cross joins
SELECT department_id, department_name,
location_id, city
FROM departments
NATURAL JOIN locations ;
