D. Richard Hipp <d...@hwaci.com> wrote: > This problem has existed in SQLite forever and has never been seen > before. So it is obscure. The simple fix is to put the ON clause on > the CROSS JOIN where it belongs.
Does CROSS JOIN allow an ON clause? That doesn't make much sense. I guess I'm missing something obvious. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users