问个SQL的问题

来源: 于 2013-03-05 19:44:49 [博客] [旧帖] [给我悄悄话] 本文已被阅读：次

I have two tables:

TABLE_A
PK Value
---- ----------
1 FOX
2 COP
3 TAXI
6 WASHINGTON
7 DELL
5 ARIZONA
4 LINCOLN
10 LUCENT

TABLE_B
PK Value
---- ----------
1 TROT
2 CAR
3 CAB
6 MONUMENT
7 PC
8 MICROSOFT
9 APPLE
11 SCOTCH

I want to have following result:

PK Value
---- ----------
1 FOX
2 COP
3 TAXI
6 WASHINGTON
7 DELL
5 ARIZONA
4 LINCOLN
10 LUCENT
8 MICROSOFT
9 APPLE
11 SCOTCH

how to write sql to get it?

Thanks