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.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________