According to sqlite3 I'm on 3.8.3: SQLite version 3.8.3 2014-02-03 14:04:11
On Sat, Jul 12, 2014 at 8:06 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 07/13/2014 12:29 AM, Staffan Tylen wrote: > >> The following statement is flagged as invalid, so what's the correct way >> of >> coding it? >> >> WITH A AS (SELECT 'A'), >> B AS (SELECT 'B') >> SELECT * >> FROM A >> UNION >> SELECT * >> FROM B >> ; >> > > This statement should work in SQLite 3.8.3 or newer. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
