Hi,

I have table a and say my user1 is inserting data into table a

so my table a is having 100 rows

I have table b and say my user2 is inserting data into table b

so my table b is having 50 rows

now I have user3 and I have table ab where I want to merge the rows of a & b

is there any command that is easy to say

rename table a to ab append

rename table b to ab append

rather than saying insert into ab select * from a union all select * from b;

Many Thanks,
Sunil Kumar Noothi.