select aa.bh ,aa.na,isnull(bb.much,0),case when isnull(bb.much,0)<aa.down then aa.down-isnull(bb.much,0) else 0 end as down,case when isnull(bb.much,0)>aa.up then isnull(bb.much,0)-aa.up else 0 end as up
from prod.dbo.aa aa left join depot.dbo.bb bb on aa.bj=bb.bh
from prod.dbo.aa aa left join depot.dbo.bb bb on aa.bj=bb.bh
From prod..aa as aa INNER JOIN depot..bb as bb
ON aa.bh=bb.bh
N_Chow(一劍飄香) ( )!!!!谢谢!