有两个仓库,有
仓库A
bookname price
---------------------
Delphi 37.5
VB 24.0仓库B
bookname price
---------------------
VC 43.0
Java 37.8怎么写SQL才能得到这样的结果
bookname price
---------------------
Delphi 37.5
VB 24.0
VC 43.0
Java 37.8
仓库A
bookname price
---------------------
Delphi 37.5
VB 24.0仓库B
bookname price
---------------------
VC 43.0
Java 37.8怎么写SQL才能得到这样的结果
bookname price
---------------------
Delphi 37.5
VB 24.0
VC 43.0
Java 37.8
union
select * from 仓库B
Access 2000
仓库A,B分别是两个表
我要用Query能够实现的
给分。
FROM 仓库A A
UNION
SELECT B.bookname AS name , B.price as bookprice
FROM 仓库B B