I'd like to be able to check whether composite keys in one table exist in another. The following syntax is supported by Oracle:
SELECT * FROM TABLE_1 WHERE ( TABLE_1.KEY_1, TABLE_1.KEY_2 ) IN ( SELECT KEY_1, KEY_2 FROM TABLE_2 ); When I try it in SQLite, I get the following error: SQL error: near ",": syntax error Can anyone advise how to do multiple-column subqueries? Thanks. ********** Confidentiality Notice & Disclaimer ********** This message, together with any attachments, is for the confidential and exclusive use of the intended addressee(s). If you receive it in error, please delete the message and its attachments from your system immediately and notify us by return e-mail. Do not disclose, copy, circulate or use any information contained in this e-mail. (1) The content of this e-mail is to be read subject to our terms of business, as applicable. (2) E-mail may be intercepted or affected by viruses and we accept no responsibility for any interception or liability for any form of viruses introduced with this e-mail. (3) The sender shall remain solely accountable for any statements, representations or opinions that are clearly his or her own and not made in the course of employment. (4) For risk, protection and security purposes, we may monitor e-mails and take appropriate action. *************************************************************** TUI Northern Europe Limited Registered in England and Wales (Number 3490138) TUI UK Limited Registered in England and Wales (Number 2830117) VAT Number: 233 3687 62 Registered Office of TUI NE and TUI UK: Greater London House, Hampstead Road, London NW1 7SD Telephone: +44 (0)20 7387 9321; Fax: +44 (0)20 7387 8451; IT Helpdesk: +44 (0)20 7383 1555; E-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]