Creating a table from another table

[trutta1]

I read the documentation on the create table command. I can not see a way to create a table as a subest ( both columns and data) form another table.
In ORACLE SQL this is done by a CREATE TABLE as Select Statement). My question is is there an equivilent statement in Pervasive?

Example:

tbl1 ( Col1, Col2, Col3) I want to create tbl2 ( col1,Col3) with the data from TBL1.

 

[mirtheil]

I'm not aware of an equivalent using Pervasive.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com