SQl Left join on null

[xtrimf]

Hi,

How to perform with qlikview join the next SQL join statement?

tnx

[MayilVahanan]

HI

You can use this query itself in qlikview. Before tat, Connect ur db to qlikview via ODBC or oledb connection, then use it..

TableName:

Load *;

Select <select_lisr>  from tableA A left join tableB B on A.key = B.Key    where B.Key is null;

Then store it in the qvd for better performance.

Next time , instead of fetch data from db, use qvd file for better performance

[CELAMBARASAN]

You can do like this

Table1:

Load Key,field1,field2 frok Table1 source;

Left Join(Table1)

Table2:

Load Key, Key As Key#,field3,field4 From Table2 Source;

Table3:

Load

     Key,

     field1,

     field2

Resident

Table1

Where Key# IS NULL;

Hope it helps

[xtrimf]

I did it this way ofcourse - but when doing it on millions of records it is not as friendly as the SQL query...

and I also need the right join to get the null value from there also...

Its not pretty

[xtrimf]

I would do that If I had connection to SQL...

I'm working with QVDs