-- Query: Books with author names SELECT b.title, a.name FROM books b LEFT JOIN authors a ON b.author_id = a.id;
Assume two tables:
: Produces a Cartesian product, combining every row of the first table with every row of the second. sql joins notes pdf