SELECT a.dd
,b.dd
FROM (
SELECT dd
FROM (
SELECT 1 AS dd
UNION ALL
SELECT 2 AS dd
)
) a
LEFT JOIN (
SELECT dd
FROM (
SELECT 1 AS dd
UNION ALL
SELECT 3 AS dd
)
) b
ON a.dd = b.dd
结果
SELECT a.dd
,b.dd
FROM (
SELECT dd
FROM (
SELECT 1 AS dd
UNION ALL
SELECT 2 AS dd
)
) a
LEFT JOIN (
SELECT dd
FROM (
SELECT 1 AS dd
UNION ALL
SELECT 3 AS dd
)
) b
ON a.dd = b.dd
结果