Subject Re: [ib-support] Table as another name
Author Helen Borrie
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
....

Cheers,
Helen

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