Question

如何把符合条件的两张表中的数据查询出来，然后放入另一张表中

RT，能举个简单例子最好，谢谢

Answer 1

你可以再新建立一个表。把那两个表的id放到里面。从而使用sql 中的select检索
或者 在select中嵌套where语句

Answer 2

A表字段ID,Address
B表字段ID,Name
C表字段ID,Address,Name
insert into C
select A.ID,A.Address,B.Name from A,B where A.ID= B.ID And A.Address='你的条件'

Answer 3

create table table_008 (
id int,val int);
insert into table_008 values(1,123);
insert into table_008 values(2,124);
insert into table_008 values(3,125);

create table table_009(
id int,val int,name varchar2(8));
insert into table_009 values (1,123,'name1');
insert into table_009 values (2,124,'name2');
insert into table_009 values (3 ,125,'name3');
insert into table_009 values (4,123,'name4');
insert into table_009 values (5 ,123,'name5');
insert into table_009 values (6,124,'name6');
create table table_011(
id int,
val int,
name varchar2(10));
insert into table_011(
id,val,name) select a.id,a.val,b.name from table_008 a,table_009 b where a.id=b.id;