custom SQL join in qlikview

[manoj217]

Hi All,

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.

Thanks,

Manoj

[shiveshsingh]

You can directly write the query in script editor.

Are you getting any error?

[manoj217]

yes I'm getting an error. so can you please help me the exact syntax in qlikview to join two tables in custom sql

[shiveshsingh]

Share me the query, what error are you getting?

[manoj217]

SQL SELECT COUNTRY, CITY_NAME, REGION

FROM Countries

LEFT  JOIN Cities

ON countries = cities

[manoj217]

SQL SELECT CITIES.COUNTRY, CITIES.CITY_NAME, REGION

FROM COUNTRIES

LEFT OUTER JOIN CITIES

ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE

[shiveshsingh]

Try this once

SQL SELECT COUNTRY, CITY_NAME, REGION

FROM Countries a,Cities b

where

a.countries(+) = b.cities

[sasiparupudi1]

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

[manoj217]

again im getting the same error

[PrashantSangle]

what kind of error are you getting??

can you post it??

also post document log of qvw.

Regards