不能用in的情况下查询数据

select t.cus_uid  from trade t left join custom c 

on t.cus_uid=c.cus_uid   and t.com_uid=c.com_uid   and t.com_uid='583FE1FC0E653BD5BEADC372D5DAC02E' 

where  t.com_uid='583FE1FC0E653BD5BEADC372D5DAC02E'    

and t.cus_uid is not null and c.cus_uid is null 

limit 5;