Tag: Tutorial

Keep all left-table rows and match right-table rows when present.

Keep all right-table rows (mirror of LEFT JOIN).

Keep rows from both sides whether they match or not.

Produce Cartesian products intentionally with CROSS JOIN.

Join a table to itself for hierarchies and pairing rows.

Combine result sets and remove duplicates with UNION.

Combine result sets and keep duplicates with UNION ALL.

Nest queries inside SELECT/WHERE/FROM for multi-step logic.

Write conditional logic in queries with CASE.

Use MySQL IF / IFNULL helpers for simple conditionals and null defaults.