用TOP查询出来的货号，如何再关联查询商品详情表？

[ps800]

以下SQL语句，查询了当前所在月份，销售TOP100商品的货号及销量。

sql="select top 100 Pro_number,sum(out_sum) as out_sum from StoreOutList,storeOuthead where storeOuthead.order_id=StoreOutList.order_id and month(storeOuthead.pay_date)="&month(date())&" group by Pro_number order by out_sum desc"


结果如下：


现在的问题是：上面的结果中，不是有货号pro_number了吗，我想通过货号再查询对应商品的详情。目前我用的是嵌套的，两个SQL语句。

如何整合成一个SQL语句？只执行一次？

商品详情表名：ProductINFO
内含字段：Pro_number,Pro_name,Pro_size.....

请大神指教！不胜感激！

[yooq_csdn]

如果 ProductINFO 中 Pro_number是唯一的，可以把 ProductINFO 也加进去，三表关联 内含字段：Pro_number,Pro_name,Pro_size.....

select top 100 Pro_number,max(Pro_name),max(Pro_size),sum(out_sum) as out_sum
from (StoreOutList join storeOuthead on storeOuthead.order_id=StoreOutList.order_id ) join Pro_number on Pro_number.Pro_number=StoreOutList.Pro_number
where month(storeOuthead.pay_date)="&month(date())&" 
group by Pro_number 
order by out_sum desc

[yooq_csdn]

抱歉，上面表名写错了 select top 100 Pro_number,max(Pro_name),max(Pro_size),sum(out_sum) as out_sum from (StoreOutList join storeOuthead on storeOuthead.order_id=StoreOutList.order_id ) join ProductINFO on ProductINFO .Pro_number=StoreOutList.Pro_number where month(storeOuthead.pay_date)="&month(date())&" group by Pro_number order by out_sum desc