请教查找字段

[newline]

page_table有字段page_id和page_url。
table1中有字段page_url

我要把table1中的page_url转换成page_id插入到table2中,
如何做？一起插入到table2中的还有别的列。

我现在是用
insert into table2 (customer_id,region_id,page_id,time_id)
select c_id,r_id,#####,t_id
from table1
where ()

就是不知道对应page_id的那个#####如何写，请指教，谢谢！

[txlicenhe]

insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a
join page_table b on a.page_url = b.page_id
where ()

[txlicenhe]

或:
insert into table2 (customer_id,region_id,page_id,time_id)
select c_id,r_id,(select page_id from page_table where page_url = table1.page_url ),t_id
from table1
where ()

[sdhdy]

insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a,page_table b
where a.page_url=b.page_url

[gmlxf]

insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a,page_table b where a.page_url = b.page_url
where ()

[sunshareforever]

insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a inner
join page_table b on a.page_url = b.page_id where ()

[zjcxc]

楼主的表结构再清晰一点.
table2中有其他列,这些列和要插入的数据是什么关系?

我怎么看像是应该用更新语句来处理啊?

[zjcxc]

--不知道楼主是否这个意思?
insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a join page_table b on a.page_url = b.page_url
where ()

[LoveSQL]

insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a
join page_table b on a.page_url = b.page_url
where ()

[newline]

谢谢大家，回答这么快！
我试了马可的两种方法，就是那个意思。
不过不知道数据量很大的时候，这两种和后面的几种方法哪个更优呢？

[zjcxc]

--当然是join的方法快

insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a join page_table b on a.page_url = b.page_url
where ()

[newline]

谢谢！