Translate more than one join in sql to QlikView Script

[Anonymous]

Hi guys, i have one sql query like:

SELECT A.*, B* FROM A INNER JOIN B on ... LEFT JOIN C on ...

But i have allready these three tables on qvd files. So i want to eliminate that sql query, creating just a script that make the same joins, but reading from my qvds. How should i do that? I thought this solution, but the results was not the same of the sql query:

LOAD * FROM A.QVD;

INNER JOIN

LOAD * FROM B.QVD;

LEFT JOIN

LOAD ID FROM C.QVD

[anbu1984]

A_B:

LOAD * FROM A.QVD;

INNER JOIN

LOAD * FROM B.QVD;

LEFT JOIN(A_B)

LOAD ID FROM C.QVD

[Anonymous]

Hi Danilo,

Try below codes:

INNER:

LOAD * FROM A.QVD;

INNER JOIN

LOAD * FROM B.QVD;

NoConcatenate

LOAD * Resident INNER;

LEFT JOIN

LOAD ID FROM C.QVD;

or you can try:

INNER:

LOAD * FROM A.QVD;

INNER JOIN

LOAD * FROM B.QVD;

NoConcatenate

LEFT JOIN(INNER)

LOAD ID FROM C.QVD;

Hope it helps.

Regards

Nitha

[Anonymous]

Thanks ANGU for your answer... but it gave me the same results...

[Anonymous]

Thanks Nitha for your answer... but it gave me the same results... and the last solution you gave me alerted an error: WRONG COMBINATION. I think we can't use Noconcatenate together with JOIN

[anbu1984]

Is join key columns have same names in all tables?

[PabloOrtiz]

Hi Danilo, try this:

Table1:

LOAD * FROM A.QVD;

INNER JOIN

LOAD * FROM B.QVD;

Table2:

LOAD ID FROM C.QVD;

noconcatenate

Table3:

load * resident Table1;

left join (Table1)

load * resident Table2;

drop table Table1;

drop table Table2;

[Anonymous]

Hi Danilo,

Can you explain in detail what output you need?