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]


---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com

[Non-text portions of this message have been removed]