Re: [sqlite] DELETE and alias

Oliver Peters wrote: > sqlite> DELETE FROM a w > ...> WHERE EXISTS( > ...> SELECT 1 FROM b WHERE id = w.id) > ...> ; > Error: near "w": syntax error SQL syntax doesn't allow for an alias in DELETE statement (nor in INSERT or UPDATE). See if this helps: delete from a where id in (select i

[sqlite] DELETE and alias

Hello, I tried the following with the CLI (3.7.5 under WinXP): CREATE TABLE a( id INTEGER PRIMARY KEY AUTOINCREMENT, sometext TEXT); INSERT INTO "a" VALUES(1,'hannes'); INSERT INTO "a" VALUES(2,'walther'); INSERT INTO "a" VALUES(3,'homer'); CREATE TABLE b( id INTEGER PRIMARY KEY); INSERT INTO "b"