小弟有一个导表的语句,可是效果总不尽人意。
语句意思如下:
insert into table_temp (field1,field2,field3) select t.field1,t.field2,t.field3 from tableA a,tableB b
where a.id in ('001','002','003'...) and a.totemp=0 and a.hao is not null and a.id=b.id and b.deleted=0请求高手指教一下,谢谢各位了。
语句意思如下:
insert into table_temp (field1,field2,field3) select t.field1,t.field2,t.field3 from tableA a,tableB b
where a.id in ('001','002','003'...) and a.totemp=0 and a.hao is not null and a.id=b.id and b.deleted=0请求高手指教一下,谢谢各位了。
原本的SQL句子很复杂,这里就暂且用这个简单的例子说明一下吧
where a.id in ('001','002','003'...) and a.totemp=0 and nvl(a.hao,'')<>'' and a.id=b.id and b.deleted=0