0

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
AlxVallejo
  • 3,066
  • 6
  • 50
  • 74
  • https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS –  Jul 11 '18 at 05:33

1 Answers1

1

You are using double quotes where you should actually be using single quotes. Single quotes denote values, while double quotes represent columns and tables, etc. You can find out more about the difference here.

Jake
  • 990
  • 1
  • 10
  • 17