8 Replies Latest reply: Oct 29, 2012 1:01 PM by mayilvahanan ramasamy RSS

    How to exclude values from table in load statement

      Hello,

       

      I am trying to load a table to QV but exclude rows where column A = 'X'.  What is the syntax for this?  I thought I could just add a WHERE statement but can't find the correct way to do this.  Here is my code currently:

       

       

      SQL

      SELECT *
      FROM CIA.dbo."CU_Prem_Mbrship";

       

      Let me know if that is not clear.  Thanks.

       

      Craig