hi Welsh Corgi,
i need to optimised query
***********************************
SELECT S.RokokID, S.PitaCukai, S.GudangID, S.Calculate, S.StockQtyBTG
FROM [#Stocks] S
LEFT JOIN tblSATBonRokok B (READUNCOMMITTED)
ON S.BonRokokID = B.BonRokokID AND S.DSOLocalID = B.DSOLocalID
LEFT JOIN tblSATGoodsTransaction...