LEFT JOIN in Postgres

Ok what's wrong with this SQL query:

select j.* from judge as j 
left join user as u on j.user_id = u.id 
where u.email="john@example.com";
ERROR:  column "john@example.com" does not exist

1 answer