Sergey,

I know Mark does a lot with Oracle. I assume he's experienced what I did. When I worked with Oracle, it was required of me to use short, if not 1 char, aliases. I haven't worked enough with folks in a big SQL Server shop to see if they do the same.

PF

>>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.