select * from IA_Subsidiary where ID not in (select autoid from rdrecords)
或select * from IA_Subsidiary where ID not in (select autoid from rdrecords)and cinvcode='存货编码'
查到后还得进总帐查
IA_Summary
select * from IA_Subsidiary where ID not in (select autoid from rdrecords)
或select * from IA_Subsidiary where ID not in (select autoid from rdrecords)and cinvcode='存货编码'
查到后还得进总帐查
IA_Summary