create table #dm_yd(ypid varchar(100), ypmc varchar(100), grj varchar(100))create table #aaa(ypid varchar(100), ypmc varchar(100), grj varchar(100))update #dm_yd set grj=B.grj
from #dm_yd A inner join #aaa B on A.ypmc=B.ypmc
where A.grj='0.00'drop table #dm_yd,#aaa
from #dm_yd A inner join #aaa B on A.ypmc=B.ypmc
where A.grj='0.00'drop table #dm_yd,#aaa
谢谢各位!
(select dm_yd.ypid from dm_yd,aaa where dm_yd.grj='0.00' and dm_yd.ypmc=aaa.ypmc) 我试了下没有问题你看看符合你的要求不`