Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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. help with an example syntax

My data Base is Oracle not a SQL is it possible to do Custom sql in Qlikview.

Thanks,

Manoj

8 Replies
Qrishna
Master
Master

First define your connection,(it would be something like below)

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;

and then select the table or view:

Table:

SQL

SELECT * from tttt;

It doesnot matter what data source it is oracle or netezza or teradata until you can execute/accepts a sql statement at the database level.

Qrishna
Master
Master

Dont duplicate the threads.

Custom SQL join in qlikview

please close/delete the other duplicate thread.

manoj217
Creator III
Creator III
Author

I want to join two tables in custom sql itself

Qrishna
Master
Master

Yes you can perform join logics just the way you do in sql server/TOAD .

Just add a prefix SQL as shown above and you write your own sql queries.

eg:

Table:

SQL

SELECT * from tttt

join Table 2 Where Table1.Field = Table2.Field;

manoj217
Creator III
Creator III
Author

for oracle database SQL is necessary, because while connecting the oracle database It will generates only Select  * from table.

Qrishna
Master
Master

yes thats what i was saying.add a prefix SQL and write whatever query you want.no matter what it is.oracle or sql or netezza untill your database accepts your SQL query.

manoj217
Creator III
Creator III
Author

i hv wrote  the same oracle query into the qlikview but it is showing error. i hv copy pasted the oracle query into the qlikview

sasiparupudi1
Master III
Master III

Please paste you sql and the error here