Re: syntax error on WHERE clause... - Mailing list pgsql-novice

Robert Poor <rdpoor@gmail.com> writes:
> I'm getting syntax errors in what (I thought) is a simple query.  This
> query works in SQLite, but in psql 8.3.14 gets:

>   ERROR:  syntax error at or near "WHERE"

> Here's the query:

> SELECT (d4.digit * 10000 + d3.digit * 1000 + d2.digit * 100 + d1.digit
> * 10 + d0.digit) AS date
>              FROM digits AS d0
>        INNER JOIN digits AS d1
>        INNER JOIN digits AS d2
>        INNER JOIN digits AS d3
>        INNER JOIN digits AS d4
>             WHERE (d4.digit * 10000 + d3.digit * 1000 + d2.digit * 100
> + d1.digit * 10 + d0.digit) < 33
>          ORDER BY date;

> Any idea what's wrong?

INNER JOIN requires an ON clause.  If you really don't need any
additional join conditions than what's in the WHERE, you could write
CROSS JOIN, or you could just put commas there.

            regards, tom lane