42702 — Ambiguous Column

Wat veroorzaakt deze fout

A join query references a column name present in more than one table without qualification.

Hoe op te lossen

Qualify the column with the table name or alias. Always use table aliases in JOIN queries.

-- ambiguous_column: qualify with table name
SELECT u.id FROM users u JOIN orders o ON u.id = o.user_id;