Crystal Reports Select Expert Vs SQL

Message

   Hi:

My SQL doesn't have order date = 2004 in my where clause but it exists in select expert. Does any one know why.?

Thanks
Vijay

select expert looks like

{Customer.Region} in ["BC", "CA"] and
{Orders.Order Amount} > $1000.00 and
Year({Orders.Order Date}) = 2004

SQL looks like

 SELECT `Customer`.`Customer Name`, `Customer`.`City`, `Customer`.`Region`, `Orders`.`Order Amount`, `Orders`.`Order ID`, `Orders`.`Order Date`
 FROM   `Customer` `Customer` INNER JOIN `Orders` `Orders` ON `Customer`.`Customer ID`=`Orders`.`Customer ID`
 WHERE  (`Customer`.`Region`='BC' OR `Customer`.`Region`='CA') AND `Orders`.`Order Amount`>1000