如何在一个表中一些字段插入一个查询结果的同时在另一些字段中插入其它的值？
insert into pd_biao（pd_id,pd_pdsj,pd_jg）values (200704240001,20070424,10001) and(pd_order_id,pd_order_name,pd_order_guige,pd_order_dangwei,pd_order_scdz,pd_order_jhj,pd_kcsl) select 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 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
