select B.* from cus_001 b where b.ps_<>'RUN' AND B.CUSNOC,B.PARTNAME NOT exists (SELECT 1 FROM CUS_PSINFO where B.CUSNOC=CUS_PSINFO.CUSNOC and B.PARTNAME =CUS_PSINFO.PARTNAME);
select B.* from cus_001 b where b.ps_<>'RUN' AND B.CUSNOC NOT IN (SELECT CUSNOC FROM CUS_PSINFO) and B.PARTNAME not in (SELECT PARTNAME FROM CUS_PSINFO)
AND B.CUSNOC NOT IN (SELECT CUSNOC FROM CUS_PSINFO)
and B.PARTNAME not in (SELECT PARTNAME FROM CUS_PSINFO)