On 5 Oct 2010, at 1:14pm, Igor Tandetnik wrote: > Simon Slavin <slav...@bigfraud.org> wrote: >> On 5 Oct 2010, at 10:43am, Mail wrote: >> >>> SELECT COUNT(DISTINCT t0.Z_PK) FROM ZFFFOOD t0 WHERE (t0.ZFOODGROUP = ? AND >>> (SELECT COUNT(*) FROM ZFFWEIGHT t1 WHERE (t0.Z_PK = >>> t1.ZFOOD) ) > ?) >> >> Did you miss out 'AS' from your FROM clause between ZFFFOOD and t0 ? And >> again in the sub-SELECT ? > > AS keyword is always optional.
I just noticed that on the syntax diagram. Here's me trying to make my code understandable but SQL doesn't care. Bah. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users