I am trying to build a query which will find the costs from a set of tables where the client has costs.
The client has a cost on booking a fee, he has a hotel room cost and a room facility cost.
My query brings up what I want but each result is repeated 3 times.
I don't know why, can someone correct me please.
The client has a cost on booking a fee, he has a hotel room cost and a room facility cost.
My query brings up what I want but each result is repeated 3 times.
I don't know why, can someone correct me please.
Code:
SELECT DISTINCT Addresses.ID, Holiday_Bookings.Initial_Cost, Room_Facilities.Cost, Rooms.BasicCostPerNight
FROM ((Room_Facilities INNER JOIN ((Hotels INNER JOIN Rooms ON Hotels.HotelID = Rooms.HotelID) INNER JOIN Stops ON Hotels.HotelID = Stops.HotelID) ON Room_Facilities.FacilityID = Rooms.FacilityID) INNER JOIN (Routes INNER JOIN WalkTypes ON Routes.RouteID = WalkTypes.RouteID) ON Stops.StopID = Routes.Arrive_In) INNER JOIN (Holiday_Bookings INNER JOIN (Groups INNER JOIN (Clients INNER JOIN Addresses ON Clients.ID = Addresses.ID) ON Groups.ID = Clients.GroupID) ON Holiday_Bookings.ID = Clients.ClientID) ON WalkTypes.Walk_TypeID = Groups.GroupID;