insert into

[ring]

假如我要完成如
insert into table1(f1,f2) values ('f1',select f3 from table2)
注:select f3 from table2 只返回一行,因为f3是primary key
的功能该怎么办?
怎么在一句话里写出来?

[929]

insert into table1(f1,f2) select f1,table2.f3 from table2

[929]

对不起，少写了个引号。
我想这里“F1”是个常数。
insert into table1(f1,f2) select 'f1',table2.f3 from table2

[蝈蝈俊]

select f3 from table2 只返回一行?????????????

[EdwinYeah]

929的回答让我的问题解决了!thank you very much indeed!