Hi There

I am having trouble with this, any ideas please:

SELECT DISTINCT
LT.clotdescription,
LTx.dlTTxDate,
PS.Debit,
ST.Code,
ST.Description_1,
ST.AveUCst,
ST.ucIIDesignNo
From _etblLotTrackingTx AS LTx
INNER JOIN _etblLotTracking AS LT on LT.idLotTracking = LTx.iLotTrackingID
INNER JOIN PostSt AS PS on PS.iLotID = LT.idLotTracking
INNER JOIN StkItem AS ST on ST.StockLink = PS.AccountLink
WHERE Ltx.iLTTxTrCodeID = 43 and PS.TrCodeID = 43