On 12 Dec 2010, at 5:39pm, George Roberge wrote: > 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.
Generally speaking, avoid the compound statements like INSERT ... SELECT and SELECT ... SELECT. They are complicated and slow. For your INSERT just supply the values you need, and if you need a two-table SELECT try to find an appropriate SELECT ... JOIN. As you wrote above, you should definitely read a new books or web sites on SQL for beginners. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
