SQLite version 3.8.6 2014-07-07 18:03:38 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .version SQLite 3.8.6 2014-07-07 18:03:38 1cec1e030035e5253fb7ebbdfe5c1a3029e4e29b sqlite> WITH A AS (SELECT 'A'), ...> B AS (SELECT 'B') ...> SELECT * ...> FROM A ...> UNION ...> SELECT * ...> FROM B ...> ; A B sqlite>
>-----Original Message----- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Staffan Tylen >Sent: Saturday, 12 July, 2014 11:30 >To: sqlite-users@sqlite.org >Subject: [sqlite] WITH syntax error > >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 > ; > >Staffan >_______________________________________________ >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
