求一个SQL文！！！急在线等！！分不够揭帖后马上开贴加分！！！
customer_idchair_cdeffect_d migration_yn
1 1 2007-07-24 16:15:01
1 1 2007-09-11 0:00:000
1 1 2007-09-12 0:00:000
1 1 2007-09-13 0:00:000
1 1 2007-09-20 0:00:000
1 1 2007-09-21 0:00:000
1 2 2007-09-11 0:00:000

要求只显示按customer_id，chair_cd，effect_d分组后小于当天日期的记录，如果某一个组中有大于当天日期的记录就不显示这个组即显示如下：
customer_idchair_cdeffect_d migration_yn
1 2 2007-09-11 0:00:000

[解决办法]
select * from table group by customer_id, chair_cd, effect_d having effect_d < current date