SELECT T1.CARMODELPKID,COUNT(1) FROM RT_CUSTALLOCRESULT TLEFT JOIN VM_CARINFO T1 ON T1.FRAMENO = T.FRAMENOLEFT JOIN RT_CUSTFOLLOWUP T2 ON T2.REGNO = T.REGNOWHERE T1.CARMODELPKID IS NOT NULL AND T2.DEFEATREASON IS NOT NULL GROUP BY CARMODELPKID
本文共 243 字，大约阅读时间需要 1 分钟。
SELECT T1.CARMODELPKID,COUNT(1) FROM RT_CUSTALLOCRESULT TLEFT JOIN VM_CARINFO T1 ON T1.FRAMENO = T.FRAMENOLEFT JOIN RT_CUSTFOLLOWUP T2 ON T2.REGNO = T.REGNOWHERE T1.CARMODELPKID IS NOT NULL AND T2.DEFEATREASON IS NOT NULL GROUP BY CARMODELPKID
转载地址：http://vpxex.baihongyu.com/