-- t1 and t2 are tables.
-- The result shows fields from
-- both t1 and t2 together in a single record.
SELECT * FROM t1 LEFT JOIN t2 ON (t2.a=t1.a);