=?ISO-8859-1?Q?Nis_J=F8rgensen?= <nis(at)superlativ(dot)dk> 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