[AccessD] Alias Table Name

The most common reasons are to give the table a more meaningful name that's 
easier to remember or to give it a name that's shorter -- both making the 
reference easier to work with in code.

Susan H.


> Dear List:
>
> In a legacy app I came across some queries which in the QBE had 'alias'ed
> tables (or maybe queries).  one called P was joined to one called A.  The
> list of field names didn't correspond to any table.  There are a lot of
> queries so I didn't look through them to see if a query matched the field
> list in either P or A.
>
> But I've never seen this done.  Why would you do this?  How can you tell
> what the source of the fields in the aliased table is?  Is there some
> performance gain or other reason for doing this?
>
> MTIA,
>
> Rocky
>
>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com