select a.id,(a.pieces-isnull(b.pieces,0))as pieces from
(select product_id,sum(pieces)as pieces from orderproduct group by product_id)a
left join selectTC b on a.product_id=b.product_id
(select product_id,sum(pieces)as pieces from orderproduct group by product_id)a
left join selectTC b on a.product_id=b.product_id
解决方案 »
- SQL中,关于字符串如何按规律进行循环分割的问题求解
- 写一个连续记录大于4的sql语句 跪求
- 请教关于存储过程的问题.
- 能结决这个问题因该是高手了吧(最好是一个Select)
- 大家来帮我看看这个存储过程中游标的使用是否正确,但我无法达到返回多条记录!!
- 用游标打开的数据集,能否知道该数据集的行数?
- 作业执行包错误:用户'sa'登陆失败。请教高手指点,在线等候.......
- 请高手指点一下,一条SQL语句
- 如何写一个存储过程,使用参数传表名,如果数据库中存在该表,则drop it
- sql server2000的log问题
- 小问题,急急急 在线等待?????
- 关于系统存储过程msforeachtable 的问题
from (select product_id,pieces=sum(pieces) from orderproduct group by product_id)a
left join selectTC b on a.product_id=b.product_id
from orderproduct as a Left Join selectTC as b
on a.product_id=b.product_id
group by a.product_id
from (select product_id,pieces=sum(pieces) from orderproduct group by product_id)a
left join selectTC b on a.product_id=b.product_id
(select product_id,sum(pieces)as pieces from orderproduct group by product_id)a
left join selectTC b on a.product_id=b.product_id
(select product_id,sum(pieces)as pieces from orderproduct group by product_id)a
left join selectTC b on a.product_id=b.product_id
from (select product_id,pieces=sum(pieces) from orderproduct
group by product_id)a
left join (select product_id,pieces=sum(pieces)
from selectTC group by product_id)b
on a.product_id=b.product_id
但是都无法实现我想要的功能,因为在SelectTC表中也会有重复的product_id
LBYYBL(o_o)语句是若selectTC中有重复的product_id,则无法统计.
chd2001 的语句是若orderproduct中不包含selectTC中的product_id,则其对应的pieces值为空.
谢谢大家,还有没有更加完美的?