search the database to get date between using mssql

down vote favorite // i have this select statement ("Select * From Room LEFT JOIN booking ON (Room.RoomId = booking.RoomId) GETDATE() BETWEEN bookin.checkindate '" + TxtCheckIn.Text + "' AND booking.checkoutdate '" + TxtCheckOut.Text + "'" + " ORDER BY Room.RoomType"); /* can some one tell me how to correct that statement as all i want to do is to check in the booking table if the date match the checkin and check out date selected by users, but if it doesnt match, the query should show all rooms in the room table even if it is in the booking table provided that they have different date*/
...