I present a simplification of my problem here:
I have two tables, Table1 and Table2, both of which contain a column: City.
Table1.City contains 3 entries: Rome, Delhi, Boston.
Table2.City contains 2 entries: Rome, Delhi.
I want to select the city from Table1 that EXISTS in Table1 AND NOT IN Table2. (Boston)
Can someone please give me the correct syntax to accomplish the above? I appreciate your help.
Regards,
Jay.
I have two tables, Table1 and Table2, both of which contain a column: City.
Table1.City contains 3 entries: Rome, Delhi, Boston.
Table2.City contains 2 entries: Rome, Delhi.
I want to select the city from Table1 that EXISTS in Table1 AND NOT IN Table2. (Boston)
Can someone please give me the correct syntax to accomplish the above? I appreciate your help.
Regards,
Jay.