🚀 go-pugleaf

It is not possible to create a table from a table (or a trigger or a 
stored procedure). The InterBase 7.5 and 2007 Trial editions which are 
currently available for download include the Language Refence manual.

nuria wrote:
> Hello, I'm starting in InterBase SQL and I'm looking for reference manuals, I found this Languaje Reference from InterBase 6.0 Beta documentation from here, it's the best I could find:
> http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_download_documentation
> is there any other?
> 
> Is it possible to CREATE a table from another? 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);
> 
> Or you do it using INSERT?
> 
> 
> 

-- 
CREATE DOMAIN NEW_COMPANY AS CHAR(8) DEFAULT 'CODEGEAR' CHECK (VALUE <> 
'BORLAND') NOT NULL;