求一查询语句

fid name date
  2 aaa 2011-06-11
  5 bbb 2011-06-12
  5 aaa 2011-06-11
  2 aaa 2011-06-12
  3 ccc 2011-06-12
  2 aaa 2011-06-11
=======================================
我想要得到fid为2或name为aaa的2011-06-11的数据
select * from aaa where fid='2' or name='aaa' and date='2011-06-11'
这样出来的数据，有其它日期的数据，应该怎么写呢

select * from aaa where (fid='2' or name='aaa') and date='2011-06-11'