两个表互相插入数据

insert into Td_safe_InsureParas
(
InsureTypeID,
CityID,
CarTypeID,
CarSeatTypeID,
Item1Value,
Item2Value,
Item3Value,
Item4Value,
Item5Value,
Item6Value,
ResultValue
)
select
InsureTypeID,
CityID,
CarTypeID,
CarSeatTypeID,
Item1Value,
Item2Value,
Item3Value,
Item4Value,
Item5Value,
Item6Value,
ResultValue
from Td_safe_InsureParas where 1=1 and insuretypeid=221 and cityid=1

posted on 2008-03-08 10:42  Jingnan  阅读(278)  评论(0编辑  收藏  举报

导航