select TestA.CID,
(case when QTY2 != QTY then QTY2 else QTY end ) as QTYfrom TestA left join TestB on TestA.CID = TestB.CID本文共 191 字，大约阅读时间需要 1 分钟。
select TestA.CID,
(case when QTY2 != QTY then QTY2 else QTY end ) as QTYfrom TestA left join TestB on TestA.CID = TestB.CID转载于:https://www.cnblogs.com/yzenet/archive/2013/01/11/2856731.html
