On 28/03/07, Alejandro Garcia <aleplgr@...> wrote:
> Is this the forum for simple/newbie SQL questions?
>
> Is it possible in InterBase 7.5 create a table from another table? I'm reading the specification of the CREATE satatement but can't find how
> Like this:
>
> CREATE TABLE suppliers
> AS (SELECT companies.id, companies.address, categories.cat_type
> FROM companies, categories
> WHERE companies.id = categories.id
> AND companies.id > 1000);
>
>
>
> CREATE TABLE table [EXTERNAL [FILE] ' filespec']
> ( <col_def> [, <col_def> | <tconstraint> …]);
> <col_def> = col {< datatype> | COMPUTED [BY] (< expr>) | domain}
> [DEFAULT { literal | NULL | USER}]
> [NOT NULL]
> [ <col_constraint>]
> [COLLATE collation]