3 Replies Latest reply: Nov 23, 2015 5:52 AM by balraj ahlawat RSS

    How do i do two where clauses in the load script?

    lakwinder singh

      Hi Guys,

       

      How do i do a double where clause? what am i doing wrong in the following code?  Thank you in advance.

       

       

       

      FROM Warehouse.dbo."XXXXXX"

       

      WHERE PRODUCT IN ('XXX','YYY','ZZZ')

       

      and

       

      WHERE MONTH IN ('XXX','YYYYY','ZZZZZ')

       

       

      ;------------------------------------------------------------------------------------- ALSO TRIED OR

       

      FROM Warehouse.dbo."XXXXXX"

       

      WHERE PRODUCT IN ('XXX','YYY','ZZZ')

       

      or

       

      WHERE MONTH IN ('XXX','YYYYY','ZZZZZ')