The original code was:
[mw_shl_code=sql,true]insert Group1
select * from(
select * Group2
union
select * from Group3
union
select * from Group4
)t[/mw_shl_code]
The code now is:
[mw_shl_code=sql,true]insert Group1
select * from(
select QQNum,Nick,Age,Gender,Auth,QunNum from Group2
union
select QQNum,Nick,Age,Gender,Auth,QunNum from Group3
union
select QQNum,Nick,Age,Gender,Auth,QunNum from Group4
)t[/mw_shl_code]
Successfully solved!!
|
Posted on 2/9/2015 11:12:05 AM
