你用了左连接,这样会保证 TEL_SMS_CONTENT 这个表里的记录显示完整,当连接条件不满足时,右表TEL_PRODUCT 中的字段就会为空。 tips: 注意将你贴出的代码格式一下,方便阅读:SELECT TSC.ID ID, TSC.USER_ID USER_ID, USER_ID / 5 AS GSEND_TIME, TO_CHAR(SEND_TIME, 'YYYY-MM-DD HH24:MI:SS') SEND_TIME, CASE WHEN TSC.PRI = 0 THEN '最高' ELSE '普通' END PRI, TSC.CONTENT CONTENT, TO_CHAR(CREATE_TIME, 'YYYY-MM-DD HH24:MI:SS') CREATE_TIME, TSC.RESULT RESULT, CASE WHEN TSC.STATUS = 0 THEN '通过' WHEN TSC.STATUS = 1 THEN '不通过' WHEN TSC.STATUS = 2 THEN '审核中' END STATUS, TP.CP_ID CP_ID, TP.PRODUCTNAME PRODUCTNAME, TP.CITY CITY FROM TEL_SMS_CONTENT TSC LEFT JOIN TEL_PRODUCT TP ON TSC.PRODUCT_ID = TP.PRODUCT_ID WHERE TSC.ID = ?
你用了左连接,这样会保证 TEL_SMS_CONTENT 这个表里的记录显示完整,当连接条件不满足时,右表TEL_PRODUCT 中的字段就会为空。 tips: 注意将你贴出的代码格式一下,方便阅读:SELECT TSC.ID ID, TSC.USER_ID USER_ID, USER_ID / 5 AS GSEND_TIME, TO_CHAR(SEND_TIME, 'YYYY-MM-DD HH24:MI:SS') SEND_TIME, CASE WHEN TSC.PRI = 0 THEN '最高' ELSE '普通' END PRI, TSC.CONTENT CONTENT, TO_CHAR(CREATE_TIME, 'YYYY-MM-DD HH24:MI:SS') CREATE_TIME, TSC.RESULT RESULT, CASE WHEN TSC.STATUS = 0 THEN '通过' WHEN TSC.STATUS = 1 THEN '不通过' WHEN TSC.STATUS = 2 THEN '审核中' END STATUS, TP.CP_ID CP_ID, TP.PRODUCTNAME PRODUCTNAME, TP.CITY CITY FROM TEL_SMS_CONTENT TSC LEFT JOIN TEL_PRODUCT TP ON TSC.PRODUCT_ID = TP.PRODUCT_ID WHERE TSC.ID = ?代码怎样格式化,一直没研究明白
SELECT TSC.ID ID,TSC.USER_ID USER_ID,USER_ID/5 AS GSEND_TIME,TO_CHAR(SEND_TIME,'YYYY-MM-DD HH24:MI:SS') SEND_TIME,CASE WHEN TSC.PRI = 0 THEN '最高' ELSE '普通' END PRI,TSC.CONTENT CONTENT,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS') CREATE_TIME,TSC.RESULT RESULT,CASE WHEN TSC.STATUS = 0 THEN '通过' WHEN TSC.STATUS = 1 THEN '不通过' WHEN TSC.STATUS = 2 THEN '审核中' END STATUS,TP.CP_ID CP_ID,TP.PRODUCTNAME PRODUCTNAME,TP.CITY CITY FROM TEL_SMS_CONTENT TSC LEFT JOIN TEL_PRODUCT TP ON TSC.PRODUCT_ID = TP.PRODUCT_ID WHERE TSC.ID =?SELECT TSC.ID ID,TSC.USER_ID USER_ID,USER_ID/5 AS GSEND_TIME,TO_CHAR(SEND_TIME,'YYYY-MM-DD HH24:MI:SS') SEND_TIME,CASE WHEN TSC.PRI = 0 THEN '最高' ELSE '普通' END PRI,TSC.CONTENT CONTENT,TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS') CREATE_TIME,TSC.RESULT RESULT,CASE WHEN TSC.STATUS = 0 THEN '通过' WHEN TSC.STATUS = 1 THEN '不通过' WHEN TSC.STATUS = 2 THEN '审核中' END STATUS,TP.CP_ID CP_ID,TP.PRODUCTNAME PRODUCTNAME,TP.CITY CITY FROM TEL_SMS_CONTENT TSC LEFT JOIN TEL_PRODUCT TP ON TSC.PRODUCT_ID = TP.ID WHERE TSC.ID =?试试,呵呵
SELECT TSC.ID ID, TSC.USER_ID USER_ID, USER_ID/5 AS GSEND_TIME, TO_CHAR(SEND_TIME,'YYYY-MM-DD HH24:MI:SS') SEND_TIME, CASE WHEN TSC.PRI = 0 THEN '最高' ELSE '普通' END PRI, TSC.CONTENT CONTENT, TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS') CREATE_TIME, TSC.RESULT RESULT, CASE WHEN TSC.STATUS = 0 THEN '通过' WHEN TSC.STATUS = 1 THEN '不通过' WHEN TSC.STATUS = 2 THEN '审核中' END STATUS, TP.CP_ID CP_ID,T P.PRODUCTNAME PRODUCTNAME, TP.CITY CITY FROM TEL_SMS_CONTENT TSC LEFT JOIN TEL_PRODUCT TP ON TSC.PRODUCT_ID = TP.ID WHERE TSC.ID =? 这样就好了
tips: 注意将你贴出的代码格式一下,方便阅读:SELECT TSC.ID ID,
TSC.USER_ID USER_ID,
USER_ID / 5 AS GSEND_TIME,
TO_CHAR(SEND_TIME, 'YYYY-MM-DD HH24:MI:SS') SEND_TIME,
CASE
WHEN TSC.PRI = 0 THEN
'最高'
ELSE
'普通'
END PRI,
TSC.CONTENT CONTENT,
TO_CHAR(CREATE_TIME, 'YYYY-MM-DD HH24:MI:SS') CREATE_TIME,
TSC.RESULT RESULT,
CASE
WHEN TSC.STATUS = 0 THEN
'通过'
WHEN TSC.STATUS = 1 THEN
'不通过'
WHEN TSC.STATUS = 2 THEN
'审核中'
END STATUS,
TP.CP_ID CP_ID,
TP.PRODUCTNAME PRODUCTNAME,
TP.CITY CITY
FROM TEL_SMS_CONTENT TSC
LEFT JOIN TEL_PRODUCT TP
ON TSC.PRODUCT_ID = TP.PRODUCT_ID
WHERE TSC.ID = ?
tips: 注意将你贴出的代码格式一下,方便阅读:SELECT TSC.ID ID,
TSC.USER_ID USER_ID,
USER_ID / 5 AS GSEND_TIME,
TO_CHAR(SEND_TIME, 'YYYY-MM-DD HH24:MI:SS') SEND_TIME,
CASE
WHEN TSC.PRI = 0 THEN
'最高'
ELSE
'普通'
END PRI,
TSC.CONTENT CONTENT,
TO_CHAR(CREATE_TIME, 'YYYY-MM-DD HH24:MI:SS') CREATE_TIME,
TSC.RESULT RESULT,
CASE
WHEN TSC.STATUS = 0 THEN
'通过'
WHEN TSC.STATUS = 1 THEN
'不通过'
WHEN TSC.STATUS = 2 THEN
'审核中'
END STATUS,
TP.CP_ID CP_ID,
TP.PRODUCTNAME PRODUCTNAME,
TP.CITY CITY
FROM TEL_SMS_CONTENT TSC
LEFT JOIN TEL_PRODUCT TP
ON TSC.PRODUCT_ID = TP.PRODUCT_ID
WHERE TSC.ID = ?代码怎样格式化,一直没研究明白
2.3.将你的代码放置在两对[]中间tips:你回复某人的时候可以点击“引用”
2.3.将你的代码放置在两对[]中间tips:你回复某人的时候可以点击“引用”多谢指点,我知道哪错了,也知道如何格式代码了,多谢
TSC.USER_ID USER_ID,
USER_ID/5 AS GSEND_TIME,
TO_CHAR(SEND_TIME,'YYYY-MM-DD HH24:MI:SS') SEND_TIME,
CASE
WHEN TSC.PRI = 0
THEN '最高'
ELSE '普通'
END PRI,
TSC.CONTENT CONTENT,
TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS') CREATE_TIME,
TSC.RESULT RESULT,
CASE
WHEN TSC.STATUS = 0
THEN
'通过' WHEN
TSC.STATUS = 1
THEN '不通过'
WHEN TSC.STATUS = 2
THEN '审核中'
END STATUS,
TP.CP_ID CP_ID,T
P.PRODUCTNAME PRODUCTNAME,
TP.CITY CITY
FROM TEL_SMS_CONTENT TSC
LEFT JOIN TEL_PRODUCT TP
ON TSC.PRODUCT_ID = TP.ID
WHERE TSC.ID =?
这样就好了