Re: sql delete

Since this is a SAS forum you can't expect us to u understand the syntax from other environments.Basically, you probably need to replace the - with a WHERE EXISTS conditions.For other differences, you should be able to detect by studying documentation and try running your code.

delete from table1 as A
where
Customer = 'TgtCust' and
Period = 'TgtPeriod' and
campctrl is null and
exists (select * from table2 where
nbid_static is null and
nbid=A.nbid and
campcode=A.campcode and
trandate=A.trandate);