select a.auto_browse_num ,sum(sale) from (select a.[autobrand],a.[autotype],b.[auto_browse_num] from AutoInfo a left join AutoPrice b on a.Autoid=b.AutoID)c group by a.auto_browse_num
select auto_browse_num ,sum(sale) from ( select a.auto_browse_num ,a.[autobrand],a.[autotype],b.[auto_browse_num],a.sale from AutoInfo a left join AutoPrice b on a.Autoid=b.AutoID group by a.auto_browse_num )M
SQL 没这样的写法吧!
select auto_browse_num ,sum(sale) from ( select a.auto_browse_num ,a.[autobrand],a.[autotype],b.[auto_browse_num],a.sale from AutoInfo a left join AutoPrice b on a.Autoid=b.AutoID group by a.auto_browse_num )M 这个是正确的
select auto_browse_num ,sum(sale) from (select a.[autobrand],a.[autotype],b.[auto_browse_num] from AutoInfo a left join AutoPrice b on a.Autoid=b.AutoID) group by auto_browse_num
(
select a.auto_browse_num ,a.[autobrand],a.[autotype],b.[auto_browse_num],a.sale from AutoInfo a
left join AutoPrice b on a.Autoid=b.AutoID
group by a.auto_browse_num
)M
(
select a.auto_browse_num ,a.[autobrand],a.[autotype],b.[auto_browse_num],a.sale from AutoInfo a
left join AutoPrice b on a.Autoid=b.AutoID
group by a.auto_browse_num
)M 这个是正确的