On Tuesday, August 22, 2017 4:47 PM Simon Slavin wrote...
On 22 Aug 2017, at 8:45pm, jose isaias cabrera <[email protected]>
wrote:
So, is there a way of combining these three INSERTS into one?
You may be able to combine the three SELECTs into one using UNION. I don’t
know
if it’ll work if they have different columns.
LSOpenProject has the same columns as client.LSOpenProjects. The same is
true for LSOpenSubProject and LSOpenJobs. I am just trying to save time
with the inner most SELECT ProjID. I guess I can do a SELECT ProjID and
then create a combined INSERT programmatically. Thanks.
josé
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
