拼成一个UNION语句
现在如果想让以下几条语句拼成一个集果集，但是他们的列表不一样，该怎么样做
SELECT ID, RESOURCE_NAME,LAST_UPDATE_TIME FROM T_CUS_AD_RESOURCES WHERE STATUS =1 AND CUSTOMER_ID =59
SELECT ID,NOTEBOOK,LAST_UPDATE_TIME FROM T_CUS_CUSTOMERS WHERE STATUS=1 AND ID =59 AND NOTEBOOK IS NOT NULL
SELECT ID,PHOTO_TITLE,LAST_UPDATE_TIME FROM T_CUS_MASTER_PRODUCTS WHERE STATUS =1 AND CUSTOMER_ID =59
SELECT ID,SHOP_NAME,LAST_UPDATE_TIME FROM T_CUS_CASES WHERE STATUS=1 AND CUSTOMER_ID=59
SELECT ID ,LAST_UPDATE_TIME ,DETAILE_TYPE,(CASE DETAILE_TYPE WHEN 6 THEN 'aa ' WHEN '7 ' THEN 'bb ' ".
" WHEN 1 THEN 'cc ' WHEN 2 THEN 'dd ' WHEN 3 THEN 'ee ' WHEN 4 THEN 'ff ' WHEN 8 THEN 'hh ' ".
" WHEN 5 THEN 'ii ' ELSE 'other 'END) AS 'CUS_DETAILE_TYPE ' FROM T_CUS_DETAILES WHERE STATUS=1
AND CUSTOMER_ID=59
[解决办法]
少的加上 " "来占位。
[解决办法]
AS
[解决办法]
可否,具体一点,他们的类型也是不一样的
