a05Events.accdb
| ReservationID | EventID | ConfRoomID | ReservationDate | DaysReserved | RoomCharge |
| 1 | 1 | 3 | 2/15/22 | 2 | ¤ 1,500.00 |
| 2 | 2 | 2 | 2/15/22 | 2 | ¤ 2,000.00 |
| 3 | 2 | 3 | 2/18/22 | 2 | ¤ 1,500.00 |
| 4 | 3 | 1 | 2/15/22 | 5 | ¤ 3,000.00 |
| 5 | 4 | 3 | 1/4/22 | 2 | ¤ 1,500.00 |
| ConfRoomRateID | ConfRoomID | MininumHotelRooms | MaximumHotelRooms | Rate |
| 1 | 1 | 0 | 29 | ¤ 6,000.00 |
| 2 | 1 | 30 | 50 | ¤ 5,000.00 |
| 3 | 1 | 51 | 90 | ¤ 4,000.00 |
| 4 | 1 | 91 | 150 | ¤ 3,000.00 |
| 5 | 1 | 150 | | ¤ 0.00 |
| 6 | 2 | 0 | 9 | ¤ 3,000.00 |
| 7 | 2 | 10 | 30 | ¤ 2,500.00 |
| 8 | 2 | 31 | 60 | ¤ 2,000.00 |
| 9 | 2 | 61 | 90 | ¤ 1,500.00 |
| 10 | 2 | 91 | | ¤ 0.00 |
| 11 | 3 | 0 | 9 | ¤ 2,000.00 |
| 12 | 3 | 10 | | ¤ 1,500.00 |
| ConfRoomID | RoomName | Capacity |
| 1 | Musica | 500 |
| 2 | Eldorado | 100 |
| 3 | Pueblo | 25 |
| EventID | EventName | EventStart | EventLength | GroupID |
| 1 | Company Retreat | 2/15/22 | 2 | 1 |
| 2 | Annual Meeting | 2/15/22 | 5 | 2 |
| 3 | Annual Meeting | 2/15/22 | 2 | 3 |
| 4 | Planning Meeting | 1/4/22 | 2 | 3 |
| GroupID | GroupName | ContactFirstName | ContactLastName | ContactPhone |
| 1 | Benson & Diaz Law Group | Mary | Williams | (505) 555-1207 |
| 2 | Dental Association of Nova Scotia | Anne | Green | (902) 555-8765 |
| 3 | Orchard Growers of the United States | Will | Goodwin | (212) 555-7889 |
SELECT tblGroup.GroupName, tblGroup.ContactFirstName, tblGroup.ContactLastName, tblEvent.EventName, tblEvent.EventStart, tblConfRes.ReservationDate, tblConfRes.DaysReserved, tblConfRes.RoomCharge, tblConfRooms.RoomName, [roomcharge]*[daysreserved] AS [Total Charge]
FROM (tblGroup INNER JOIN tblEvent ON tblGroup.GroupID = tblEvent.GroupID) INNER JOIN (tblConfRooms INNER JOIN tblConfRes ON tblConfRooms.ConfRoomID = tblConfRes.ConfRoomID) ON tblEvent.EventID = tblConfRes.EventID;
inwoodchck
