YES, that was it, thank you! It was a simple issue of the word "values" and the addition of the extra parentheses. I can see it now: the two SELECTS in parentheses are the equivalent of the "values" that would be entered.
Looks simple after seeing it. Maybe I should have taken a step back for a couple of hours..and had more coffee!! To round out the question: I don't have Access at home, and I'm learning SQLite as an easier and more portable alternative to PostgreSQL. I don't use Windows at home, and don't want to. And the "why" of this particular query: I don't know any better...LOL. I'm tooling around with the database as I read my SQL books, and try experiments on the fly. Eventually I'll try to piece together a nice functioning GUI or a better web-based movie database than I have now, but it'll take a little while. Thank you again for your reples! This list has been very helpful and educational! George R. Igor Tandetnik wrote: > Drake Wilson <[email protected]> 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. > -- www.andforthelamb.org www.outreachhockey.org They deem me mad for I will not sell my days for gold; I deem them mad for they think my days have a price. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
