How to write a subquery with "if else" condition

[#1]

Hi friends,

I have the following SQL query:

select

case when (select id from table1 where id=number) is null then 'Not Exists'

         else 'Exists'

END case,

number,name from table2;

I have created 2 QVD files with table1.qvd and table2.qvd.

I knew only this:

Load number,

        name

FROM

(qvd);

Any help is greatly appreciated.

[phaneendra_kunc]

Try this

Table1:

Load id as number

FROM

(qvd);

Table2:

Load if( exists(number),'Exists','NotExists') as XXXX,

        name

FROM

(qvd);

[jagan · Accepted solution]

HI,

Try this

Table1:

LOAD

     id

FROM Table1.QVD;

LEFT JOIN (Table1)

LOAD

     Number as id,

     Name

FROM Table2.qvd;

Data:

LOAD

     id,

     Name,

     If(IsNull(Name), 'Not Exists', 'Exists') AS Status

RESIDENT Table1;

DROP TABLE Table1;

Hope this helps you.

Regards,

Jagan.

[#4]

thank you phaneendra

[#5]

thanks jagan mohan. It worked.