主题：sql语句请教

类似
select * from (select 产品ID,sum(数量) as 数量 from {表A} group by 产品ID) as a inner join {表B} on {表A}.产品ID = {表B}.产品ID