> I by accident mistyped an SQL query and it actually works on my Firebird
> Final Release version. Just asking if this should be so and if yes what it
> should do.
>
> SELECT * FROM Country CountryAreaCode ;
>
> Below is how the table should look like.
>
> SQL> SHOW TABLE Country;
> COUNTRYIDSQ INTEGER Not Null
> COUNTRYNAME VARCHAR(50) Not Null
> COUNTRYINTERNATIONLCODE VARCHAR(10) Not Null DEFAULT '00'
> COUNTRYCODE VARCHAR(10) Not Null
> COUNTRYAREACODE VARCHAR(10) Nullable
> COUNTRYHELPNUMBER VARCHAR(8) Nullable
> COUNTRYGMT FLOAT Not Null
> CONSTRAINT INTEG_5:
> Primary key (COUNTRYIDSQ)
> CONSTRAINT INTEG_6:
> Unique key (COUNTRYNAME)
>
> Triggers on Table COUNTRY:
> TRIGGENCOUNTRY, Sequence: 0, Type: BEFORE INSERT, Active

In your case, CountryAreaCode got the table alias name.



HTH,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com