Subject | Aliases in the query |
---|---|
Author | Ricardo |
Post date | 2005-02-18T12:43:14Z |
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
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