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或者‘ ’,现在知道了。