Drake Wilson <dr...@begriffli.ch> wrote:
> INSERT INTO "cast" (titleID, castID)
> ((SELECT titleID FROM titles WHERE title = 'Alien'),
> (SELECT artistID FROM artists WHERE lastname = 'Weaver'));
Make it
INSERT INTO "cast" (titleID, castID)
VALUES
((SELECT titleID FROM titles WHERE title = 'Alien'),
(SELECT artistID FROM artists WHERE lastname = 'Weaver'));
Note the added VALUES keyword.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
