Left Join table field to First table

[settu_periasamy]

Hi,

i have 2 qvd file and i need to join them like the below code.

Table1:

  LOAD     A1,    

               B1,

               if(not isnull(D1),0,A1) as C1   // D1 Field is in 2nd qvd    

  FROM

  qvd\1.qvd

  (qvd) where exists(F1);

  Left Join 

LOAD   D1,  E1   FROM   qvd\2.qvd   (qvd) where exists(E1);

store table1 to table1.qvd;

I'm getting an error field not found. I know D1 field not available in the 1st qvd file.

But i need the C1 field, if D1 is not null.

Could you please give the suggestion?

[jagan]

Hi,

Instead of using Exists you can directly use Inner join instead of left join

Table1:

Load

A1, B1 ,F1

from QVD1 ;

Inner Join(Table1)

Load

D1,E1 ,F1

from QVD2;

Final:

Load *,

If(Not IsNull(D1),0, A1) AS C1

Resident Table1;

Drop Table Table1;

Regards,

Jagan.