SELECT DACONN as shipment_, OQDLIX as delivery_, DAE0B4 as carNo, OQRIDN as cono, OAWHLO as wh,
OAORDT as orderDate, OARLDT as sendDate 
FROM MVXJDTA.DCONSI a 
JOIN MVXJDTA.MHDISH b ON a.DACONN = b.OQCONN 
JOIN MVXJDTA.OOHEAD c ON b.OQRIDN = c.OAORNO 
WHERE DAE0B4 LIKE N'%รถร่วมกทม%' 

</body>
</html>