[sqlite] Insert with multiple nested selects.

[Joseph L. Casale]

Hey guys,
Trying to create a statement for use with parameters in a Python execute method
when performing inserts with multiple nested selects. I can adjust it for use
with Python, but I am having issues when there is more than one nested select.

Something such as:

INSERT OR IGNORE INTO table_a
(
    col_a,
    col_b,
    col_c,
    col_d
)
SELECT col_a FROM (SELECT id FROM table_b WHERE name=?)
,?
,?
,SELECT col_d FROM (SELECT id FROM table_c WHERE name=?);

Anyone have a hint on how to perform such as query?

Thanks,
jlc
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users