delete from rdrecords y , (select rs.rdspk, r.cCode,r.cWhCode,rs.dDate ,rs.cInvLevel,rs.cInvName, rs.iUnitCost,rs.iPrice ,r.cMemo
from rdrecords as rs left join rdrecord as r on rs.rdfk = r.rdpk
where r.cCode is null ||r.cCode='' ) x where y.rdspk=x.rdspk
这个语句那里错了呢 确定括号里的语句是一个正确的查询
from rdrecords as rs left join rdrecord as r on rs.rdfk = r.rdpk
where r.cCode is null ||r.cCode='' ) x where y.rdspk=x.rdspk
这个语句那里错了呢 确定括号里的语句是一个正确的查询
from rdrecords as rs left join rdrecord as r on rs.rdfk = r.rdpk
where r.cCode is null or r.cCode='' ) x where y.rdspk=x.rdspk