Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manoj217
Creator III
Creator III

custom SQL join in qlikview

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

11 Replies
shiveshsingh
Master
Master

You can directly write the query in script editor.

Are you getting any error?

manoj217
Creator III
Creator III
Author

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
Master
Master

Share me the query, what error are you getting?

manoj217
Creator III
Creator III
Author

SQL SELECT COUNTRY, CITY_NAME, REGION

FROM Countries

LEFT  JOIN Cities

ON countries = cities

manoj217
Creator III
Creator III
Author

SQL SELECT CITIES.COUNTRY, CITIES.CITY_NAME, REGION

FROM COUNTRIES

LEFT OUTER JOIN CITIES

ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE

shiveshsingh
Master
Master

Try this once

SQL SELECT COUNTRY, CITY_NAME, REGION

FROM Countries a,Cities b

where

a.countries(+) = b.cities

sasiparupudi1
Master III
Master III

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
Creator III
Creator III
Author

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂