2 Replies Latest reply: Apr 18, 2013 7:47 PM by 998459 RSS

    [nQSError: 30001 ] Only columns, designated predicated and operators

    979551
      "DEVDW".""."KDWDB"."D2_KW_STUDENT_D"."KW_STUDENT_ID" =
      "DEVDW".""."KDWDB"."F1_KW_SCHOOL_ENROLL_F"."KW_SCHOOL_ID" AND
      "DEVDW".""."KDWDB"."D2_KW_STUDENT_D"."CURRENT_FLAG" = 'Y'

      When I trid to do this way It through an error. But if I doing on this way :

      "DEVDW".""."KDWDB"."D2_KW_STUDENT_D"."KW_STUDENT_ID" =
      "DEVDW".""."KDWDB"."F1_KW_SCHOOL_ENROLL_F"."KW_SCHOOL_ID" AND
      "DEVDW".""."KDWDB"."D2_KW_STUDENT_D"."CURRENT_FLAG" =
      "DEVDW".."KDWDB"."F1_KW_SCHOOL_ENROLL_F"."CURRENT_FLAG"


      It allow me to work. But I want this on the first way. Not the second way.

      Please help me with this.

      Current Flag is *"Char 1"*.

      Please help me.