已关闭,此问题需要details or clarity。目前不接受答复。
**想改善这个问题吗?**通过editing this post添加详细信息并澄清问题。
昨天关门了。
Improve this question
SELECT
SUBSTR(A.RECORD_KEY,1,10) AS "PRODUCER_TAX_ID",
CASE
WHEN B.SEX_CODE = 'E' THEN TRIM(B.CORPORATE_NAME)
ELSE TRIM(B.FIRST_NAME) || TRIM(B.MIDDLE_NAME) || TRIM(B.LAST_NAME)
END AS "PRODUCER_NAME",
SUBSTR(A.RECORD_KEY,11,2) AS "STATE_CODE",
CHAR(C.APPT_LOB_EFF_DT) AS "APPOINTMENT_EFFECTIVE_DATE",
A.ORIGINATOR_CD AS "USER_ID",
CASE A.FILE_MAINT_TRX_CD
WHEN 'LOBC' THEN 'UPDATE'
END AS "TRANSACTION_TYPE"
1条答案
按热度按时间nwsw7zdq1#
您可以使用
UNION ALL
来执行此操作,如下所示: