On Jul 17, 2013, at 9:07 PM, Joseph L. Casale <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
