-- INNER JOIN
SELECT * FROM
left_table AS l
JOIN right_table AS r
ON r.id = l.id
-- NATURAL JOIN : Automatically joins on matching columns and does not return duplicate column values from both table (ON not allowed)
SELECT * FROM
left_table AS l
NATURAL JOIN right_table AS r
-- LATERAL JOIN : dynamic result based on subquery
SELECT *
FROM left_table AS outer, -- notice the comma here
LATERAL -- Keyword LATERAL for joining
( SELECT *
FROM right_table AS inner
WHERE outer.id = inner.id) AS lat -- The joining condition