SELECT SJ_CangChu.pinming as 品名, SJ_CangChu.xinghao as 型号, SJ_CangChu.tiaoma as 条码,sum(SJ_Order.num) as 数量
FROM dbo.SJ_Order INNER JOIN
dbo.SJ_CangChu ON SJ_Order.outer_sku_id = SJ_CangChu.tiaoma
where SJ_Order.status='WAIT_SELLER_SEND_GOODS'
group by SJ_CangChu.pinming, SJ_CangChu.xinghao, SJ_CangChu.tiaoma
union all
SELECT SJ_CangChu.pinming as 品名, SJ_CangChu.xinghao as 型号, SJ_CangChu.tiaoma as 条码,sum(SJ_Order.num) as 数量
FROM dbo.SJ_Order INNER JOIN
dbo.SJ_CangChu ON SJ_Order.outer_iid = SJ_CangChu.tiaoma
where SJ_Order.status='WAIT_SELLER_SEND_GOODS'
group by SJ_CangChu.pinming, SJ_CangChu.xinghao, SJ_CangChu.tiaoma
SELECT SJ_CangChu.pinming as 品名, SJ_CangChu.xinghao as 型号, SJ_CangChu.tiaoma as 条码,sum(SJ_Order.num) as 数量
FROM dbo.SJ_Order INNER JOIN
dbo.SJ_CangChu ON SJ_Order.outer_sku_id = SJ_CangChu.tiaoma or SJ_Order.outer_iid = SJ_CangChu.tiaoma
where SJ_Order.status='WAIT_SELLER_SEND_GOODS'
group by SJ_CangChu.pinming, SJ_CangChu.xinghao, SJ_CangChu.tiaoma
SJ_Order的新旧2个字段对应(outer_sku_id ,SJ_Order.outer_iid )分别对应SJ_CangChu.tiaoma
这2个SQL有什么区别
解决方案 »
- 求问2个基础的问题,但是我实在是想不明白了,谢谢
- 如何将ACCESS中的查询导入到sql2000的视图中?
- sql 查询求助各位大神
- 这个触发器怎么对DELETE不起作用呢? CREATE TRIGGER reminder ON titles FOR INSERT, UPDATE ,DELETE AS print '修改'
- SQL数据库转空间还原备份后,ID不能自动增长?重新设置了ID属性都没用?为什么?
- 高分请教:有谁知道查询分析器里边如何操作图像类型的数据
- 在线等,高手进
- 关于外连接的问题
- 所有者问题,请教!!谢谢。
- 如果直接将多媒体文件(流量很大)存入数据库,出现哪些问题,如何解决?
- 请教高手,按部门,分类查询SQL
- 请教这样的SQL语句如何写?
如果把union all改为union 则结果一模一样了.不过貌似用or比较好.
union all
select * from tablename where id=2
第二个语句比第一个语句的连接条件多了一个...第一个是SJ_Order.outer_sku_id = SJ_CangChu.tiaoma
按照 这个其条件去匹配.. 连接
第二个是 SJ_Order.outer_sku_id = SJ_CangChu.tiaoma or SJ_Order.outer_iid = SJ_CangChu.tiaoma
按照 两个条件去匹配做连接至于on 后面跟 where 还是 and 我感觉在内连接这里没有什么区别...
外连接上on后面跟and 是连接条件..on 后面跟where 是过滤条件
用括号括起来看看
ON (SJ_Order.outer_sku_id = SJ_CangChu.tiaoma or SJ_Order.outer_iid = SJ_CangChu.tiaoma)
where SJ_Order.status='WAIT_SELLER_SEND_GOODS'