Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
manoj217
Contributor 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
Honored Contributor

Re: custom SQL join in qlikview

You can directly write the query in script editor.

Are you getting any error?

manoj217
Contributor III

Re: custom SQL join in qlikview

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
Honored Contributor

Re: custom SQL join in qlikview

Share me the query, what error are you getting?

manoj217
Contributor III

Re: custom SQL join in qlikview

SQL SELECT COUNTRY, CITY_NAME, REGION

FROM Countries

LEFT  JOIN Cities

ON countries = cities

manoj217
Contributor III

Re: custom SQL join in qlikview

SQL SELECT CITIES.COUNTRY, CITIES.CITY_NAME, REGION

FROM COUNTRIES

LEFT OUTER JOIN CITIES

ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE

shiveshsingh
Honored Contributor

Re: custom SQL join in qlikview

Try this once

SQL SELECT COUNTRY, CITY_NAME, REGION

FROM Countries a,Cities b

where

a.countries(+) = b.cities

sasiparupudi1
Honored Contributor III

Re: custom SQL join 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

manoj217
Contributor III

Re: custom SQL join in qlikview

again im getting the same error

Re: custom SQL join in qlikview

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.