Subject | Re: [ib-support] Table as another name |
---|---|
Author | Ann W. Harrison |
Post date | 2001-02-22T00:00:03Z |
>At 10:34 AM 2/22/2001 +1100, Helen Borrie wrote:
> > > >SELECT FS.NAME AS FS_NAME, TS.NAME AS TS_NAME
> > > > FROM WAYBILL AS WB
>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