以下语句正确:
select c1,c2 from
(
select c1,c2
from ta
where ... limit 100
) t1
union ALL
select c1,c3 from
( select c1,c3
from tb
where ... limit 100
) t2
以下语句正确:
select c1,c2 from
(
select c1,c2
from ta
where ... limit 100
) t1
union ALL
select c1,c3 from
( select c1,c3
from tb
where ... limit 100
) t1