Try this:

SELECT ContactID

FROM tblContact

GROUP by ContactID

HAVING SUM(CASE WHEN City='Toronto' THEN 1 ELSE 0 END) > 0 AND

SUM(CASE WHEN City='Vancouver'...