Question

insert into select 可以加where条件么

Answer 1

可以加

例:

insert into [表名]([列名1],[列名2],[列名3],...)
select [列名1],[列名2],[列名3],... from  [表名2] 
where [条件]

Answer 2

一、INSERT INTO (SELECT FROM)语句(可连表、可加限制条件where子句)
语句形式为：INSERT INTO table2(a,b,d) (SELECT a,b,d FROM table1)

二、如下代码：
INSERT INTO T_COMMISSION
(TYPE_NUM,PRODUCT_NUM,FAST_COMMISSION,CREATE_DATE,EMPLOYEE_ID
,OTHER_FAST_COMMISSION,MONEY,FAST_PRICE,ALL_FAST_COMMISSION
,OTHER_FAST_PRICE,ALL_FAST_PRICE)
(SELECT T1.TYPE_NUM,T2.PRODUCT_NUM,0,SYSDATE,'15145117218',0
,T2.MONEY,T2.MONEY,0,T2.MONEY,T2.MONEY
FROM T_COMMISSION_TYPE T1,T_PRODUCT_TYPE T2 WHERE T1.TYPE_NUM='default_type')

Answer 3

insert into table （a,b,c）
select * from
( select table1.a,table1.b,table2.c
from table1.a=table2.a(+)--左连接
where table1.a='a')