SQL文！分不够揭帖后马上开贴加分！

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

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

------解决方案--------------------------------------------------------
select * from table group by customer_id, chair_cd, effect_d having effect_d < current date