[sqlite] WITH syntax error

[Staffan Tylen]

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