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