select TestA.CID,
(case when QTY2 != QTY then QTY2 else QTY end ) as QTYfrom TestA left join TestB on TestA.CID = TestB.CID本文共 124 字，大约阅读时间需要 1 分钟。
select TestA.CID,
(case when QTY2 != QTY then QTY2 else QTY end ) as QTYfrom TestA left join TestB on TestA.CID = TestB.CID转载地址：http://ngnuo.baihongyu.com/
