insert into SERV_PRODUCT(area_id,serv_id,serv_seq_nbr,product_id,serv_prod_seq,
product_quantity,charge,cycle_type_id,apply_date,product_state,
state,state_date,oper_serial_nbr,gale_date,exp_date,oper_date)
select.area_id,a.serv_id,a.serv_seq_nbr,a.product_id,a.serv_prod_seq,
a.product_quantity,a.charge,a.cycle_type_id,a.apply_date,
a.product_state,a.state,a.state_date,a.oper_serial_nbr,a.gale_date,
a.exp_date,a.oper_date
from ORI_SERV_PRODUCT a,ORI_SERV b
where a.area_id = an_area_id and a.serv_id = b.serv_id
and a.serv_seq_nbr = b.serv_seq_nbr and b.serv_devicen_serv_id_max;
该语句执行就长时间没有结果,两个表的记录都不到20万,请问各位大侠,这是为什么?
|