>>All she did was "alias" the real table name with a shorter name. That expression is not the selection from 2 different tables. I would have aliased them to even shorter aliases.

>>FROM wms_ITRN_all A
>>   INNER JOIN Inventory B
>>      ON A.Sku = B.primary_reference
>>   LEFT OUTER JOIN wms_AdjustmentDetail_All C
>>      ON A.ItrnKey = C.ItrnKey
>>

>
>Mark,
>
>Aliasing tableas to one letter names is the same bad idea as usindg one letter variables. It makes code unreadable and hard to maintain.

True. I have only used 1-letter names to alias tables in SQL for remote DBs. I never do that for native VFP tables since they would remain open. About the only 3-letter names I use for variables were like lnI or lnJ for counting in a FOR/ENDFOR.