ambil pembanding in mas bragas

select
    mp.value as item_code,
    c.documentno as po,
    uom.uomsymbol as uomIn,
    sum(mi_line.QtyEntered) as qtyIn
from m_inoutline mi_line
left join m_inout  as mi on mi_line .m_inout_id=mi.m_inout_id
left join c_orderline  as c_line on mi_line .c_orderline_id  = c_line.c_orderline_id
left join c_order as c on c_line .c_order_id = c_line .c_order_id
left join m_product as mp on mi_line.m_product_id = mp.m_product_id
left join c_uom as uom on mi_line.c_uom_id =uom.c_uom_id
where mi.issotrx = 'N' and mi.docstatus  = 'CO' and
(mp.value,c.documentno) in
(
('80004328.RT.YK-095A-66.5','POSL1909A/E0083')
)
group by
    mp.value,
    c.documentno,
    uom.uomsymbol