Why doesnt work NESTED JOINS in SQL SELECT

Mon, 07 Jan 2013 21:40:53 GMT

Hi, Im using the SQL SELECT join, because my tables have a lot of entries and I just wanna filter some of them. If I use the LOAD or qlikview joins I get the join just fine, but I cant avoid the whole scan of the table of the DB. I also used the option of LOAD WHERE EXIST but still takes a lot of time.

So I have this and works like charms:

TEST_JOIN:

SQL SELECT *

FROM myDB.TABLE1 A INNER JOIN myDB.TABLE2 B ON A.USER = B.PARTNER

WHERE A.COORD = 'TEST'

AND A.ACTIVO = 'X';

But I dont know why when I add a new nested join it doesnt work, I get "OLEDB read failed"

TEST_JOIN2:

SQL SELECT *

FROM ( myDB.TABLE1 A INNER JOIN myDB.TABLE2 B ON A.USER = B.PARTNER )

INNER JOIN myDB.TABLE3 C ON B.PARTNER_GUID = C.PARTNER_NO

WHERE A.COORD = 'TEST'

AND A.ACTIVO = 'X';

Also tried without the "(" ")"

SQL SELECT *

FROM myDB.TABLE1 A INNER JOIN myDB.TABLE2 B ON A.USER = B.PARTNER

INNER JOIN myDB.TABLE3 C ON B.PARTNER_GUID = C.PARTNER_NO

WHERE A.COORD = 'TEST'

AND A.ACTIVO = 'X';

Doesnt work either.

Im still pretty newbie in qlikview, I know that qlikview first scan and fetch the SQL select statment and then apply the LOAD and makes the joins by itself, i just wanna be able to "filter" somehow the entries. And this it isnt because Im stubborn my problem is becasue I connect via a VPN to the DB, so when Im not on the same building where the DB is it takes FOREVER to run the script.

Thx

Re: Why doesnt work NESTED JOINS in SQL SELECT

hic — Mon, 07 Jan 2013 23:05:17 GMT

QlikView sends the entire SELECT statement (as a string) to the OLE DB provider, so if you get an error, it's because the OLE DB provider doesn't support the syntax/construction. QlikView does nothing to interpret the SELECT.

HIC

topic Re: Why doesnt work NESTED JOINS in SQL SELECT in QlikView

Why doesnt work NESTED JOINS in SQL SELECT

Re: Why doesnt work NESTED JOINS in SQL SELECT