Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasa1
Creator II
Creator II

WHERE Exists

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

1 Solution

Accepted Solutions
MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
prieper
Master II
Master II

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

HTH
Peter

MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
srinivasa1
Creator II
Creator II
Author

yes your right thanks