Postgres SQL select query syntax

Question

I have this SQL statement, I am getting a syntax error:

SELECT
  *
FROM
  user_table
  INNER JOIN (
    klass_table
    LEFT JOIN room_table
  )

Syntax error is vague, it says:

You have an error in your SQL syntax; it seems the error is around: ')' at line 8

Perhaps I am missing an ON clause?

Perhaps, what happened when you added one? Doesn’t really make sense to have a left join without one — Sami Kuhmonen
– Sami Kuhmonen, Commented Feb 16, 2019 at 7:03
Yeah it works when I add an ON clause to the LEFT JOIN. It doesn't look like I need an ON clause for INNER JOIN, tho. — user1604294
– user1604294, Commented Feb 16, 2019 at 7:27
Yes, their function is different so their requirements are also different. — Sami Kuhmonen
– Sami Kuhmonen, Commented Feb 16, 2019 at 7:36
You do need a join condition (specified with ON) for an inner join. Those parentheses are pretty much useless by the way: from user_table join klass_table on ... left join room_table on ... works just as well — user330315
– user330315, Commented Feb 16, 2019 at 7:38

CodeOfLife · Accepted Answer · 2019-02-16 07:20:32Z

1

You have not mentioned the columns on which you are doing the inner join.So basically you are missing the "ON" keyword for both the joins.

answered Feb 16, 2019 at 7:20

CodeOfLife

3331 gold badge3 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yeah the ON keyword only seems to be necessary for the LEFT JOIN, not necessary for the INNER JOIN

@rakim: the ON condition is needed for all joins except cross join