WHERE Exists

[srinivasa1]

This could be unintelligent question still I need to do.

I have  two table like
A and B

Here A is QVD and B Is direct connected Db and  trying use where exists like below

A:

LOAD

EMP_CODE AS EMPCODE,

NAME

FROM A.QVD

B:

load

EMP_CODE AS EMPCODE,

dept

SQL SELECT *FROM  B

WHERE(Exists EMPCODE, EMP_CODE);

WILL IT WORK ,IHAVE TRIED BUT ITS NOT WORKING PLS GUIDE ME

Thanks

[prieper]

The EXISTS-command belongs to QlikView, not SQL. Thus should be put in a preceding load over the SQL-statement.

HTH
Peter

[MayilVahanan · Accepted solution]

HI

A:

LOAD

EMP_CODE AS EMPCODE,

NAME

FROM A.QVD;

B:

load

EMP_CODE AS EMPCODE,

dept

WHERE Exists (EMPCODE, EMP_CODE);

SQL SELECT *FROM  B;

Hope it helps

[srinivasa1]

yes your right thanks