[Solved] SQL query where clause is ambiguous [duplicate]

Use an explicit JOIN with ON:

SELECT c.*, u.*  -- you should really explicitly list the columns
FROM contacts c JOIN
     users u
     ON c.user_id = u.user_id
WHERE u.user_id = 1 ;