请教SQL,如何把两个表的两个字段查询出来的数据放到同一字段中?
SELECT (BCSDB.BCSDB_BCMC, BZSDB.BZSDB_BZMC) as aa
FROM BCSDB, BZSDB 这句怎么改?
BCSDB.BCSDB_BCMC BZSDB.BZSDB_BZMC
1 A
2 B
3 C
aa
1
2
3
A
B
C
SELECT (BCSDB.BCSDB_BCMC, BZSDB.BZSDB_BZMC) as aa
FROM BCSDB, BZSDB 这句怎么改?
BCSDB.BCSDB_BCMC BZSDB.BZSDB_BZMC
1 A
2 B
3 C
aa
1
2
3
A
B
C
from BCSDB
union all
select BZSDB.BZSDB_BZMC
from BZSDB
union all
select BZSDB_BZMC from BZSDB