Do you mean:
SELECT INVOICE_NO, INVOICE_TOTAL FROM INVOICES WHERE INV_CUST_ID IN
(SELECT CUST_ID FROM CUSTOMERS WHERE CUST_PCODE='nnn');
then, SQLite supports it.
I have a need to use a nested SQL statement, via the IN verb. SQLite
cannot handle nested SQL statements, so does anyone know of a
workaround for this problem?
Thanks, TJH
--
Kind regards
Brian
"A moment's insight is sometimes worth a lifetime's experience"
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
