8 Replies Latest reply: Oct 29, 2012 1:01 PM by Mayil Vahanan Ramasamy RSS

    How to exclude values from table in load statement



      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:




      SELECT *
      FROM CIA.dbo."CU_Prem_Mbrship";


      Let me know if that is not clear.  Thanks.