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. help with an example syntax

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

Thanks,

Manoj

[Qrishna]

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]

Dont duplicate the threads.

Custom SQL join in qlikview

please close/delete the other duplicate thread.

[manoj217]

I want to join two tables in custom sql itself

[Qrishna]

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]

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

[Qrishna]

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]

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]

Please paste you sql and the error here