SELECT a.OKCUNO as CUNO,a.OKCUNM as CUNM,b.OAORNO as CONO,b.OAORTP as OrderType,a.OKORTP as CustomerType
FROM MVXJDTA.OCUSMA a
JOIN MVXJDTA.OOHEAD b on a.OKCUNO = b.OACUNO
WHERE
SUBSTRING(b.OAORTP, 1,1) <> SUBSTRING(a.OKORTP, 1,1)
AND b.OAORDT LIKE '20250428%'
AND b.OAORTP in ('021','921')ระบบการตรวจเช็คการนำเข้าข้อมูล