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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register 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. 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