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]
