Hi ChangZhuo (2018.08.14_03:55:36_+0200) > * NCTU accounting office needs the start date / end date of every > dormitory rooms to write off NCTU budget for dormitory.
I sent you the result of this query: SELECT room, min(date) as first_arrival, DATE(max(date) + INTERVAL '1 day') AS last_departure FROM register_accomm LEFT JOIN register_accomm_nights ON register_accomm.id = register_accomm_nights.accomm_id LEFT JOIN register_accommnight ON register_accomm_nights.accommnight_id = register_accommnight.id LEFT JOIN front_desk_checkin ON register_accomm.attendee_id = front_desk_checkin.attendee_id WHERE room != '' AND front_desk_checkin.id IS NOT NULL GROUP BY room ORDER BY room; SR -- Stefano Rivera http://tumbleweed.org.za/ +1 415 683 3272
