การเปรียบเทีนยวัน check in กับ check out ห้องพักนะครับผม

select *,DATE_FORMAT(date, '%d/%m/%Y') AS date1,DATE_FORMAT(room_datein, '%d/%m/%Y') AS room_datein1,DATE_FORMAT(room_dateout, '%d/%m/%Y') AS room_dateout1 from tblreserve inner join tblreserveheader on tblreserve.reserveheaderid = tblreserveheader.reserveheaderid where status = '2' and checkstatus = 0 and room_datein = '2012-02-04' and roomnum not in (select max(date) from tblcheckout where date >'2012-02-04' and roomnum = 101 order by date desc) order by roomnum