我该如何写这样的SQL语句!

Question

insert into 表B(field1,field2,field3,field4) 
values(tableA.FieldbyName('field1').Asstring,
       tableA.FieldbyName('field2').Asstring,
       tableA.FieldbyName('field3').Asstring,
       tableA.FieldbyName('field4').Asstring)
TableA就是你的表A,假使都是字符类型的

Answer 1

insert into tableB(Field1,Field2,Field3,Field4)
select Field1,Field2,Field3,Field4
from tableA
where Field1='3'

Answer 2

insert into tableB(Field1,Field2,Field3,Field4)
select Field1,Field2,Field3,Field4
from tableA
where Field1='3'

Answer 3

我的指针不一定是3,那如何SQL中写呢

Answer 4

tadoquery1.sql.add('insert into 表B(field1,field2,field3,field4) 
values('''+tableA.FieldbyName('field1').Asstring+''','''+
       tableA.FieldbyName('field2').Asstring+''','''+
       tableA.FieldbyName('field3').Asstring''','''+
       tableA.FieldbyName('field4').Asstring'''');

Answer 5

insert into tableb(field1,field2,field3,field4)
(select field1,field2,field3,field4
from table a
where field1='')

Answer 6

如果tableb字段只有四个的话，可以这样写
insert into tableb
(select ...)