现在如果想让以下几条语句拼成一个集果集,但是他们的列表不一样,该怎么样做
SELECT ID, RESOURCE_NAME,LAST_UPDATE_TIME FROM T_CUS_AD_RESOURCES WHERE STATUS =1 AND CUSTOMER_ID =59SELECT 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
SELECT ID, RESOURCE_NAME,LAST_UPDATE_TIME FROM T_CUS_AD_RESOURCES WHERE STATUS =1 AND CUSTOMER_ID =59SELECT 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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货