select * from qmd_myCustomers where partnerType <> 'BPL' select * from qmd_partnersRaw where partnerType in ( )