日期:2014-05-17 浏览次数:20774 次
WITH TABLE1 AS(
SELECT '1' AS ID, 'A' AS NAME FROM dual
union all
SELECT '2' AS ID, '' AS NAME FROM dual
union all
SELECT '3' AS ID, '' AS NAME FROM dual
union all
SELECT '4' AS ID, '' AS NAME FROM dual
),
TABLE2 AS (
SELECT '1' AS ID, 'M' AS NAME,'ok' AS DC FROM dual
union all
SELECT '2' AS ID, 'N' AS NAME,'NO' AS DC FROM dual
union all
SELECT '3' AS ID, 'O' AS NAME,'NOT' AS DC FROM dual
union all
SELECT '4' AS ID, 'D' AS NAME,'NOT' AS DC FROM dual
),
TABLE3 AS (
SELECT '1' AS ID, 'MCC' AS NAME FROM dual
union all
SELECT '2' AS ID, 'NVV' AS NAME FROM dual
union all
SELECT '3' AS ID, 'OTT' AS NAME FROM dual
union all &n