=?ISO-8859-1?Q?Nis_J=F8rgensen?= <[EMAIL PROTECTED]> writes: > The problem seems to be that you expect
> SELECT a > FROM b,c LEFT JOIN d > to be interpreted as > SELECT a > FROM (b CROSS JOIN c) LEFT JOIN d The depressing part of this report is that it sounds like sqlite has emulated this bit of mysql brain-damage ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org