8 Replies Latest reply: Nov 25, 2009 2:27 PM by Lee Alderdice RSS

    Cannot get 'WHERE' to work in script

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       





       

       

      QlikView will not accept the 'WHERE' statement in the script. What am i doing wrong?

       

      ODBC

      SQL

       

      SELECT *

      FROM

       

      DKXXX400.EGDTA.FAKSTAP1;

       

      WHERE FKKUNR = '900000500';

       

      WHERE FKKUNR = '900000500';

      WHERE FKKUNR = '900000500';



      CONNECT TO EGDTA;

       

       

      SQL

       

      SELECT *

      FROM

       

      DKXXX400.EGDTA.FAKSTAP1;

       

      WHERE FKKUNR = '900000500';

       

      WHERE FKKUNR = '900000500';

      WHERE FKKUNR = '900000500';



      CONNECT TO EGDTA;

       

      CONNECT TO EGDTA;

      SQL

       

      SELECT *

      FROM

       

      DKXXX400.EGDTA.FAKSTAP1;

       

      WHERE FKKUNR = '900000500';

       

      WHERE FKKUNR = '900000500';

      WHERE FKKUNR = '900000500';