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

[Anonymous]

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')

[Anonymous · Accepted solution]

try this:

FROM Warehouse.dbo."XXXXXX"

WHERE PRODUCT IN ('XXX','YYY','ZZZ') or/and MONTH IN ('XXX','YYYYY','ZZZZZ')

//No need to repeat where clause again and again

[Anonymous]

Cheers that worked, i won't forget the double where in a rush now.  Thanks

[Anonymous]

Cross checking is always importatnt