SELECT a.country,a.state,a.state FROM hz_locations a GROUP by a.country, a.state UNION ALL SELECT LOOKUP_CODE,lookup_code ,meaning FROM AR_LOOKUPS L WHERE LOOKUP_TYPE='REMIT'
View Text - HTML Formatted
SELECT A.COUNTRY , A.STATE , A.STATE FROM HZ_LOCATIONS A GROUP BY A.COUNTRY , A.STATE UNION ALL SELECT LOOKUP_CODE , LOOKUP_CODE , MEANING FROM AR_LOOKUPS L WHERE LOOKUP_TYPE='REMIT'