select DISTINCT ITM.*
from ITEM as ITM
left outer join STOCK as STK
             on ITM.ITEM_CODE = STK.ITEM_CODE
where STK.ITEM_CODE is not NULL
and   STK.LAST_DELIVERY_DATE > '2022-12-01'
and   CAST(STK.ACTUAL_AMT as real) > 0
and   CAST(ITM.STOCK_MANAGEMENT_TYPE as real) = 1