7 Replies Latest reply: May 24, 2012 4:40 AM by Laurens Schepers RSS

    Nested Select SQL Where Clause

    slind0503

      Wondering if I can do a nested select SQL statement in QLikview script... Qlikview seems grouchy though, however, I'm certain my syntax is not correct...

       

      I have a QlikView file:TEMPFILE with only one "SchoolCode" field that contains distinct SchoolCode values.

      So,

      I want to LOAD new data from a database... using only data with SchoolCodes that are in the tempfile...

      LOAD * From DBO.TABLENAME

      WHERE SchoolCodes IN (select distinct SchoolCode from TEMPFILE)

      ;

      What am I doing wrong?

      Stephanie