>I need the records where reg_meeid is CAMEX2000 to CAMEX2004. Using Inlist will give me any records where at least one of the condition is true. How can I get where all of the condition is true?
>

WHERE reg_meeid BETWEEN "CAMEX2000" AND "CAMEX2004" ;