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