Pronto agora vai select * from reservas r group by r.dtini, r.dtfinal having '10.01.2011' between min(r.dtini) and max(r.dtfinal) or '20.01.2011' between min(r.dtini) and max(r.dtfinal)