select a.gsmc , isnull(sr,0) sr from table1 m
left join
(select gsdm ,sum(sr) sr from table2 group by gsdm having(sum(sr)) > 3000) n
on m.gsdm = n.gsdm
left join
(select gsdm ,sum(sr) sr from table2 group by gsdm having(sum(sr)) > 3000) n
on m.gsdm = n.gsdm
left join
(select gsdm ,sum(sr) sr from table2 group by gsdm having(sum(sr)) > 3000) n
on m.gsdm = n.gsdm
select a.gsmc,sum(isnull(b.sr,0)) as se
from table1 a
left join table2 b on a.gsdm=b.gsdm and b.se>30000
where a.gsdm='1300'
isnull在oracle 中不能使用?
left join
(select gsdm ,sum(sr) sr from @table2 group by gsdm having(sum(sr)) > 3000) n
on m.gsdm = n.gsdm
select a.gsmc , nvl(n.sr,0) sr from table1 m
left join
(select gsdm ,sum(sr) sr from table2 group by gsdm having(sum(sr)) > 3000) n
on m.gsdm = n.gsdm
left join(select gsdm ,sum(sr) sr from Table_2 group by gsdm having(sum(sr)) > 3000) as bon a.gsdm = b.gsdm
from (select sum(sr)as sr from table2 where gsndm =a.gsndm )as b ,gsdm a where gsmc ='汉阳分公司'