SQL语句如下: SELECT ' ', ' ', ' ', ' ', K.RENTER, T.CONTRACT_CODE, T.SHOULD_REPAY_DATE, '租金', T.SHOULD_REPAY_AMT, ' ', ' ', T.SHOULD_REPAY_AMT, ' ', ' ', ' ', ' ', ' ' FROM CLC_REPAY_PLAN T, CLC_ASSET_PACT J, CLC_CONTRACT_INFO K WHERE T.CALC_TYPE = '4' AND T.INNER_ACCOUNT_ID = K.INNER_ACCOUNT_ID AND J.PACT_ID = '10000141' AND T.SHOULD_REPAY_DATE LIKE '%2011-02%' 以前不知道sql语句还可以填充null或者‘ ’,现在知道了。