insert into pd_biao(pd_id,pd_pdsj,pd_jg,pd_order_id,pd_order_name,pd_order_guige,pd_order_dangwei,pd_order_scdz,pd_order_jhj,pd_kcsl)
select 200704240001,20070424,10001,order_id,order_name,order_guige,order_dangwei,order_scdz,order_jhj,kc_sl
from kc_biao,order_biao
where kc_order_id=order_id
select 200704240001,20070424,10001,order_id,order_name,order_guige,order_dangwei,order_scdz,order_jhj,kc_sl
from kc_biao,order_biao
where kc_order_id=order_id
insert into tablename(.......) select ........
是insert 的两种常用形式,select 中除了表数据外,还可以是已知量如:1,'aa',getdate(),已赋值的变量、表达式,它们可以不属于后面的表