where clause with two criteria

[settu_periasamy]

Hi ,

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

data	Year1	Month1	Sales
A	2012	Jan	4816
B	2012	Feb	4125
C	2012	Mar	4409
D	2012	Apr	4037
E	2012	May	4972
A	2012	Jun	4497
B	2012	Jul	4333
C	2012	Aug	4526
D	2012	Sep	4985
E	2013	Jan	4596
A	2013	Feb	4460
B	2013	Mar	4061
C	2013	Apr	4024
D	2013	May	4154
E	2013	Jun	4128
A	2013	Jul	4521
B	2013	Aug	4655
C	2014	Jan	4721
D	2014	Feb	4620
E	2014	Mar	4480
A	2014	Apr	4293
B	2014	May	4172
C	2014	Jun	4201
D	2014	Jul	4212
E	2014	Aug	4406

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?

[Anonymous · Accepted solution]

Where not (

( Year1=2014' )

and

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

[tresesco]

Try like:

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