I'm not sure, but I suspect TIME is a reserve word, and therefore the best
thing to do would be to rename the table to a non-reserved name.

Mike

----- Original Message -----
From: "Ricardo" <r_p_mendes@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, February 18, 2005 6:43 AM
Subject: [firebird-support] Aliases in the query


>
>
>
> I have a table named Time and I'm trying to create a query that runs
> both in Access and Firebird. The Access query runs if I enclose the
> table name within brackets ([Time]). But Firebird doesn't accept this
> syntax. I have to put the table name within quotes ("Time"). Is there
> a way I can get the query working in both databases?
>
> Thanks
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>