On 22 Feb 2001, at 10:34, Helen Borrie wrote:

To: ib-support@yahoogroups.com
From: Helen Borrie <helebor@...>
Date sent: Thu, 22 Feb 2001 10:34:38 +1100
Send reply to: ib-support@yahoogroups.com
Subject: Re: [ib-support] Table as another name

> At 09:16 AM 21-02-01 -0500, you wrote:
>
>
> > > >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.
>
> Keep "AS" for the column aliases, just remove it for the table
> aliases.
>

Okay I think I have it now, it looks wierd but SQL is anything but
consistant.

Thanks for your help.

Paul


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