mysql> select n.email, n.type from NWR_Database n, CandidatesList c
    -> where n.email = c.email and
    -> n.type IN ('CONTRACT','ADHOC CONTRACT')
    -> and
    -> c.preference IN ('SAP','ORACLE','ORACLE CLINICALS','ORACLE DBA','ORACLE DEVELOPER','ORACLE FINANCIALS','ERP','ERP/CRM/BAAN/PSOFT/JDE','CRM','UNIX','UNIX ADMINISTRATOR','SIEBEL')
    -> ;