作者: 大梦 时间: 2014-12-02 14:42
把代码贴上来看看!作者: reallytrue 时间: 2014-12-02 17:35
SELECT * FROM A LEFT JOIN D ON TRIM(A.CUSNAME)=TRIM(D.CUSNAME)
LEFT JOIN C ON CHAR(REPEAT('0',16-LENGTH(TRIM(D.CUSNO)))||TRIM(D.CUSNO)) = C.CUSNO AND C.RECSTARTDATE <= '2014-11-30' AND
VALUE(C.RECENDDATE,'9999-12-31') >= '2014-11-30' AND C.IDTYPE = '0033' AND C.IDRECNO = '9999';