Page 1 of 1

Using a query to split a table in to two.

Posted: Fri Oct 18, 2002 4:06 am
by psmshankar
Hi all,
I got a question from my friend whether there is any query/way to
split a table(which has 5 columns) in to two???

He even don't know whether it can be done??
I am not sure whether it can be done or not??

Any idea???

Thanks
Shankar

Posted: Fri Oct 18, 2002 5:44 am
by twigletmac

Posted: Fri Oct 18, 2002 8:01 am
by mikeq
create table MYTABLE as
select this_column, that_column
from myothertable;

This will work.