Subject Re: [ib-support] Table as another name
Author Ann W. Harrison
>
> > > >SELECT FS.NAME AS FS_NAME, TS.NAME AS TS_NAME
> > > > FROM WAYBILL AS WB

At 10:34 AM 2/22/2001 +1100, Helen Borrie wrote:

>Keep "AS" for the column aliases, just remove it for the table aliases.

Thus demonstrating that SQL does not suffer from "foolish consistency".


Regards,

Ann
www.ibphoenix.com
We have answers. And a wisecrack for most occasions