SQL-fu failing as I attempt to Update using multiple joins

[modernshoggoth]

G'day all,
I'm trying to update a single table (containing plans for flights) with information from the same and other tables (containing info for organisations and locations).

tblFlightPlans contains the txt-column 'TripSummary', which is what I'm trying to update, as well as ID numbers for the origin, destination, and plane carrier (eg, Qantas). The SQL code below successfully joins tblLocations and tblFlightPlans and updates TripSummary with a text name for the flight's origin.

UPDATE [SELECT PlaceID, PlaceName FROM tblLocations]. AS test INNER JOIN tblFlightPlans ON test.PlaceID=tblFlightPlans.Leg1Origin SET TripSummary = test.PlaceName;
 

What I need is something very similar, but involving the above TWICE (two lookups), for an origin and a destination, as well as a carrier. I've tried this, which fails:

UPDATE 
[SELECT PlaceID, PlaceName FROM tblLocations]. AS Origins INNER JOIN tblFlightPlans ON Origins.PlaceID=tblFlightPlans.Leg1Origin
[SELECT PlaceID, PlaceName FROM tblLocations]. AS Destinations INNER JOIN tblFlightPlans ON Destinations.PlaceID=tblFlightPlans.Leg1Dest
[SELECT OrgID, Name FROM tblOrganisations]. AS Carriars INNER JOIN tblFlightPlans ON Carriars.OrgID=tblFlightPlans.Leg1OrgID
 
SET TripSummary = Origins.PlaceName & " to " & Destinations.PlaceName & " by " Carriars.Name; 
 

...and also this, which also fails (though again, the singular form works, if I'm only trying to update TripSummary with one PlaceName):

UPDATE tblFlightPlans 
INNER JOIN [SELECT PlaceID, PlaceName FROM tblLocations]. AS Origins ON Origins.PlaceID=tblFlightPlans.Leg1Origin 
INNER JOIN [SELECT PlaceID, PlaceName FROM tblLocations]. AS Destinations ON Destinations.PlaceID=tblFlightPlans.Leg1Dest
INNER JOIN [SELECT OrgID, Name FROM tblOrganisations]. AS Carriars ON Carriars.OrgID=tblFlightPlans.Leg1OrgID
 
SET TripSummary = Origins.PlaceName & " to " & Destinations.PlaceName & " by " Carriars.Name; 
 

What am I doing wrong? How do I approach using multiple joins in Access?

If all else fails, is there some sort of "append" function that will allow me to make 3 separate queries and tack it on to the same textbox?

Notes:
Interchanging "(xxx) AS x" and "[xxx]. AS x" gives the same errors, so I don't think it's a bracketing problem. Also, "Carriars" is deliberate, the name "Carriers" is already taken somewhere else =P

[modernshoggoth]

UPDATE: Apparrently there is such a thing as 'nested INNER JOINs'. Looking into these now, but they're pretty obtuse beasts.

[modernshoggoth]

UPDATE: Nevermind, all, got it sorted! =)
The following does what I want, ie, gives a text output of "Location1 to Location2 by Carrier1".

UPDATE 
[SELECT PlaceID, PlaceName FROM tblLocations]. AS Origins INNER JOIN 
(
[SELECT PlaceID, PlaceName FROM tblLocations]. AS Destinations INNER JOIN 
(
tblFlightPlans INNER JOIN [SELECT OrgID, Name FROM tblOrganisations]. AS Carriars ON Carriars.OrgID=tblFlightPlans.Leg1OrgID
) 
ON Destinations.PlaceID=tblFlightPlans.Leg1Dest
) 
ON Origins.PlaceID=tblFlightPlans.Leg1Origin 
 
SET TripSummary = Origins.PlaceName & " to " & Destinations.PlaceName & " by " & Carriars.Name;
 

[NeoPa]

Just to assuage your curiosity about the subquery notation, see Access QueryDefs Mis-save Subquery SQL.

Note, in most cases (except those where it seems Access recognises that it was created by itself) only the version with parentheses will be recognised.