如何在vb中实现将数据库中两张字段名相同的表合并成为一张表?

[ophilier]

如题

[bill9]

合并:是指两表逻辑上的交集还是记录的追加？

[pd163]

select * from table1 union select * form table2

[csdncb]

select * from table_a
unit all
select * from table_b

--for oracle

[small_wei]

select * into new_table from table_a,table_b where table_a.a1=table_b.b1