SELECT cu.OKCUNO as CUS_CODE, cu.OKCUNM as CUS_NAME, cu.OKCUA1+' '+cu.OKCUA2+' '+cu.OKCUA3+' '+cu.OKCUA4 as CUS_ADDR, cu.OKCUA3 as CUS_PROV, cu.OKPHNO as CUS_PHONE, cu.OKSDST as CUS_ZONE, cu.OKCFC1 as CUS_AREA, cu.OKCFC3 as CUS_ROUTE, cu.OKCFC6 as CUS_SHOP, cu.OKDTE1 as OPN_DATE, oh.OANTLA as AMT, ca.OPGEOX as LAT, ca.OPGEOY as LNG FROM MVXJDTA.OCUSMA AS cu LEFT JOIN MVXJDTA.OOHEAD AS oh ON cu.OKCUNO=oh.OACUNO INNER JOIN MVXJDTA.OCUSAD AS ca ON cu.OKCUNO=ca.OPCUNO where (((cu.OKCUNO like 'V%') and (cu.OKCUNO not like 'V0%') and (cu.OKCUNO <>'COMMISSION')) and (cu.OKCUNM not like '**%')) and (cu.OKDTE1 like '202504%') order by cu.OKCUNODump data Complete . . . All Rows is -> 0