how can i use load statement

[#1]

i want use

select *

from wpprd

where aa='b' and in ( select * from wiplot);

but in edit script, i don't know how use it..

please help me~

[anbu1984]

Connect ....;

Sql

select *

from wpprd

where aa='b' and field in ( select field from wiplot);

[#3]

A:

load a,

     d,

     c,

     d

from ~~~~ (qvd);

sql select a, d

from ~~~(qvd)

where a=1 an d in (select * from A);

it is possible??

[anbu1984]

A:

load a,

     d,

     c,

     d

from ~~~~ (qvd);

//If you are reading from qvd then sql is not required

sql select a, d

from ~~~(qvd)

where a=1 and Exists(d);

[jagan]

Hi,

Can you come with a sample values and your expected output?

Regards,

Jagan.