select distinct PRPART.part_item_no,PRPART.uom, gbitem.item_no,gbitem.stock_uom from PRPART left join gbitem on PRPART.part_item_no=gbitem.item_no and PRPART.uom<>gbitem.stock_uom order by PRPART.part_item_no
select distinct PRPART.part_item_no, PRPART.uom, gbitem.item_no, gbitem.stock_uom from PRPART join gbitem on PRPART.part_item_no=gbitem.item_no and PRPART.uom<>gbitem.stock_uom order by PRPART.part_item_no试试这个
join gbitem on PRPART.part_item_no=gbitem.item_no and PRPART.uom<>gbitem.stock_uom
order by PRPART.part_item_no
PRPART.part_item_no,
PRPART.uom,
gbitem.item_no,
gbitem.stock_uom
from PRPART join gbitem
on PRPART.part_item_no=gbitem.item_no
and PRPART.uom<>gbitem.stock_uom
order by PRPART.part_item_no试试这个