求sql

[caoyang0299]

表1
a b
1 x
1 y
2 z
表2
a c
1 o
2 p
2 q
求sql得到下面结果

a b c
1 x o
1 y
2 z p
2 q

[中国风]

;WITH a
AS
(
SELECT *,ROW_NUMBER()OVER(ORDER BY GETDATE()) AS ord FROM 表1
),b
AS
(
SELECT *,ROW_NUMBER()OVER(ORDER BY GETDATE()) AS ord FROM 表2
)
SELECT  ISNULL(a.a, b.a) AS a
       ,a.b
       ,b.c
FROM    a
        FULL JOIN b ON a.ID = b.ID
                       AND a.ord = b.ord

[caoyang0299]

结贴，给分的框框看不到，咋整。 结不了贴啦