postgresql 7.2 select r.reservation_id, f.name as facility_name, fr.name as room_name, r.status, to_char(start_date, 'Mon DD, YYYY HH12:MI AM') as full_start_date, to_char(end_date, 'Mon DD, YYYY HH12:MI AM') as full_end_date, e.name, start_date, p.first_names||' '||p.last_name as username from acs_events e join timespans s on (e.timespan_id = s.timespan_id) inner join time_intervals t on (s.interval_id = t.interval_id) inner join rr_reservations r on (e.event_id = r.reservation_id) inner join rr_rooms fr on (r.room_id = fr.room_id) inner join rr_facilities f on (f.facility_id = fr.facility_id) inner join persons p on (r.reserving_user = p.person_id) WHERE 1=1 $where_clause [template::list::filter_where_clauses -and -name room_reservations] [template::list::orderby_clause -orderby -name room_reservations]