insert into table1
(uuid, col1, col2, col3)
select b.uuid, b.col1, a.col2, a.col3
from (select a.col2, a.col3
from table2 a
group by a.col2, a.col3
order by a.col2) a,
table3 b
where a.no1 = b.no2
(uuid, col1, col2, col3)
select b.uuid, b.col1, a.col2, a.col3
from (select a.col2, a.col3
from table2 a
group by a.col2, a.col3
order by a.col2) a,
table3 b
where a.no1 = b.no2
扫一扫
4万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
