you have to do in thsese way

SELECT
T0.ItemNo T0_F1_ItemNo,
T0.ItemName T0_F2_ItemName,
T0.ItemPrice T0_F3_ItemPrice
FROM
Item T0

Or you can put your alias in "" quotes

--
Ales :)

rosimildo wrote:

> Hi guys,
>
> I have been testing out FireBird 1.5, and it does not seem to
> support simple things like "table alias".
>
> Am I wrong ?
>
> SELECT
> T0.ItemNo AS T0_F1_ItemNo,
> T0.ItemName AS T0_F2_ItemName,
> T0.ItemPrice AS T0_F3_ItemPrice
> FROM
> Item AS T0
>
> Rosimildo.
>