- 文学城
- [computer]
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
I did try this, what I got is:
墨索里尼总是有理,过去有理,现在有理,而且将来永远有理
直接用not exists 不就行了?搞的这么复杂
how to deal exist? 不搞的这么复杂
这句名言出自一部阿尔巴尼亚的电影,电影的名子是《宁死不屈》。
回复:how to deal exist? 不搞的这么复杂
OK, I'll try. Thanks, vielen dank.Merci, תוד&#
NVL for Oracle, IFNULL for MySQL, ISNULL for SqlServer