insert into t_region
select seq_region_id.nextval,t.REGION_ID,max(2), distinct r.city,r.city,'','','','1'from t_region t,t_test_region rwhere r.PROVICE=REGION_NAME; 如何让distinct可以顺利通过???????
select seq_region_id.nextval,t.REGION_ID,max(2), distinct r.city,r.city,'','','','1'from t_region t,t_test_region rwhere r.PROVICE=REGION_NAME; 如何让distinct可以顺利通过???????
这样不可以吗?
insert into t_region
select distinct seq_region_id.nextval,t.REGION_ID,max(2), r.city,r.city,'','','','1' from t_region t,t_test_region r where r.PROVICE=REGION_NAME;
select seq_region_id.nextval,t.REGION_ID,max(2),() distinct r.city,r.city,'','','','1'from t_region t,(select ... from t_test_region t_test_region group by r.city ....) as t2where t.xxx=t2.xxx
....