Select a.Code,a.Name,a.Type,
Je1=(Select ISNull(Sum(b.Je),0) From TableB b Where a.Code=b.Code),
Je2=(Select ISNull(Sum(c.Je),0) From TableC c Where a.Code=c.Code)
From TableA a
Order By a.Code
Je1=(Select ISNull(Sum(b.Je),0) From TableB b Where a.Code=b.Code),
Je2=(Select ISNull(Sum(c.Je),0) From TableC c Where a.Code=c.Code)
From TableA a
Order By a.Code
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货