Subject RE: [firebird-support] SQL Question
Author Peter Dennis
Thanks Helen.

Sorry about the non-plain text message before.

How do i do this kind of query when using the Firebird ISQL Tool?

I get this error for the following query:

SQL> select subu_name As "Suburb Name" from suburb where subu_id = 2000;
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 21
-"Suburb Name"

[] On Behalf Of Helen Borrie
Sent: Thursday, 19 April 2007 4:53 PM
Subject: Re: [firebird-support] SQL Question

At 03:43 PM 19/04/2007, you wrote:
>Hi all,
> I was just wondering whether this is the correct group to ask about SQL
>queries? If not can someone please point me in the right direction?
>Is it possible in Firebird to use column aliases in a select statement?
>For example:
> col1 AS "Student Name"
> students
> studentID = 7577;


Would you please configure your mail client to send plain text to the
lists? thanks.
^ heLen