-- Select
select count(1)
from c_invoiceline il
where il.c_orderline_id is not null
and il.m_inoutline_id is null
and exists (
  select 1
  from m_inout io
  join m_inoutline iol
  on io.m_inout_id = iol.m_inout_id
  where io.processed = 'Y'
  and iol.c_orderline_id is not null
  and iol.c_orderline_id = il.c_orderline_id
  and iol.movementqty = il.qtyinvoiced
);

-- Update
update c_invoiceline il
set m_inoutline_id = (
  select iol.m_inoutline_id
  from m_inout io
  join m_inoutline iol
  on io.m_inout_id = iol.m_inout_id
  where io.processed = 'Y'
  and iol.c_orderline_id is not null
  and iol.c_orderline_id = il.c_orderline_id
  and iol.movementqty = il.qtyinvoiced
  order by io.created desc
  limit 1
)
where il.c_orderline_id is not null
and il.m_inoutline_id is null
and exists (
  select 1
  from m_inout io
  join m_inoutline iol
  on io.m_inout_id = iol.m_inout_id
  where io.processed = 'Y'
  and iol.c_orderline_id is not null
  and iol.c_orderline_id = il.c_orderline_id
  and iol.movementqty = il.qtyinvoiced
);