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   STK.ACTUAL_AMT > 0
and   ITM.STOCK_MANAGEMENT_TYPE = 1
order by ITM.ITEM_CODE