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" VALUES(1);
INSERT INTO "b" VALUES(3);
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('a',3);
sqlite> DELETE FROM a w
...> WHERE EXISTS(
...> SELECT 1 FROM b WHERE id = w.id)
...> ;
Error: near "w": syntax error
sqlite> DELETE FROM a AS w
...> WHERE EXISTS(
...> SELECT 1 FROM b WHERE id = w.id);
Error: near "AS": syntax error
I assume that this is wanted behaviour and will happen too when I try this using
UPDATE. Could somebody explain why this has to happen? I think that using an
alias would shorten expressions sometimes.
greetings
oliver
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
