I want to join two tables in custom SQL In Qlikview , can anyone please help me how to join two tables and I don't want the preceding load, I want only custom SQL.
My data Base is Oracle not a SQL is it possible to do Custom sql in Qlikview.
You are missing alias in your SQL
SQL SELECT CITIES.COUNTRY, CITIES.CITY_NAME, REGION
FROM COUNTRIES COUNTRIES
LEFT OUTER JOIN CITIES CITES
ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE