Hi,

> Is it posible to create new table by selecting data from other tables
> with CREATE TABLE AS ?
> Thanks.

No, you cannot copy metadata like that. Several tools though, like
Database Workbench (FREE Lite Edition available!) have
"Duplicate Object" functionality.

You can insert the data from one table to another by doing
INSERT INTO NEWTABLE SELECT FROM OLDTABLE


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com