where clause with two criteria

settu_periasamy — Mon, 11 May 2015 07:32:42 GMT

Hi ,

i have the table like the below. I want all the data, except the year 2014 , and Month May, Jun, Jul & Aug.

I tried the below script

Table1:

LOAD data,

Year1,

Month1,

Sales

FROM

[data1.qvd](qvd) Where( Year1<>'2014' and Month1='May' and Month1='Jun' and Month1='Jul' and Month1='Aug');

Could you please suggest?

Re: where clause with two criteria

Anonymous — Mon, 11 May 2015 07:37:15 GMT

Where not (

( Year1=2014' )

and

( Month1='May' or Month1='Jun' or Month1='Jul' or Month1='Aug' ) ) ;

tresB — Mon, 11 May 2015 07:38:30 GMT

Try like:

Where Not ( Year1=2014 and (Month1='May' or Month1='Jun' or Month1='Jul' or Month1='Aug'));