以下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.....
请大神指教！不胜感激！
------解决思路----------------------
如果 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
------解决思路----------------------
抱歉，上面表名写错了
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