3 Replies Latest reply: Nov 29, 2012 1:21 PM by Srinivasa D RSS

    WHERE Exists

    Srinivasa D

      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