The reason for creating a sql statement the way you show is to conform to SQL standard. I'm guessing you are expecting to see both tables in the from, and then instead of JOIN.....see wms_ITRN.Sku = Inventory.primary_reference in the "Where" clause.
I forget where, but in certain circumstances, matching tables thru "Where" will not work.
PF
>I am redoing one of the programs from one of our best programmers who left.
>Why did she code FROM wms_ITRN_all wms_ITRN without a comma and then join them later ?
>
>
>
>FROM
>
> wms_ITRN_all wms_ITRN
>
> INNER JOIN
>
> Inventory
>
> ON
>
> wms_ITRN.Sku = Inventory.primary_reference
>
> LEFT OUTER JOIN
>
> wms_AdjustmentDetail_All
>
> ON wms_ITRN.ItrnKey = wms_AdjustmentDetail_All.ItrnKey
>
>Thanks
>Jim
(On an infant's shirt): Already smarter than Bush