On 21 Feb 2001, at 9:33, Helen Borrie wrote:

To: ib-support@yahoogroups.com, ib-support@yahoogroups.com
From: Helen Borrie <helebor@...>
Date sent: Wed, 21 Feb 2001 09:33:40 +1100
Send reply to: ib-support@yahoogroups.com
Subject: Re: [ib-support] Table as another name

> At 05:25 PM 20-02-01 -0500, Paul Schmidt wrote:
> >
> >Hello List:
> >
> >I have a Paradox query that contains roughly the following syntax,
> >okay I retyped it, and changed the table and field names to protect
> >the guilty (me :-).
> >
> >SELECT
> >FS.NAME AS FS_NAME,
> >TS.NAME AS TS_NAME
> >FROM WAYBILL AS WB
>
> "AS" isn't used for aliasing table names...
>
> >SELECT
> >FS.NAME FS_NAME,
> >TS.NAME TS_NAME
> >FROM WAYBILL WB
> ....

So I just take the word AS out? It seems to be OK for the field
names, so I'll just it out on the tables, and see if that works, if
it doesn't I'll create a view, and use that for one of them.

Thanks,

Paul






Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com