Example for multi column sub query:

SELECT * FROM CUSTOMER
WHERE (STATE, CITY ) IN ( SELECT STATE, CITY FROM STATE_CITY)