On Jul 17, 2013, at 9:07 PM, Joseph L. Casale <jcas...@activenetwerx.com> wrote:
> I am using Python to query a table for all its rows, for each row, I query > related rows from a > second table, then perform some processing and insert in to a third table. > > What is the technically correct approach for this? >From the above outline, one SQL statement: insert into tableA ( ... ) select ... from tableB join tableC on tableC... = tableB… "When in Rome, do as the Romans do" -- Ambrose, allegedly _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users