how convert SQL select with subquery to Access query

[eugzl]

Hi All.
How to convert this Select statement to Access query

select
RequestID
, RequestDate
, Department
, FirstName
, LastName
, TicketNo
, Amount
, DeviceType &' '& Brand & ' '& Model as Device
, Facility & ' ' & Building & ' ' & Wing & cast(Floor as varchar(10)) & '-' & Room as Location
from tblRequests r
left join (
            select
            DeviceID
            , DeviceType
            , Brand
            , Model
            from tblDevices d
            left join tblBrands b
            on d.BrandID=b.BrandID
            left join tblDeviceTypes dt
            on d.DeviceTypeID=dt.DeviceTypeID
            left join tblModels m
            on d.ModelID=m.ModelID) as d
on r.DeviceID=d.DeviceID
left join (
            select
            LocationID
            , Facility
            , Building
            , Wing
            , Floor
            , Room
            from tblLocations l
            left join tblFacilities fa
            on l.FacilityID=fa.FacilityID
            left join tblBuildings b
            on l.BuildingID=b.BuildingID
            left join tblWings w
            on l.WingID=w.WingID
            left join tblFloors fl
            on l.FloorID=fl.FloorID) as l
on r.LocationID=l.LocationID

I will appreciate for help. Thanks.

[June7]

Access gets picky about parentheses around JOIN clauses. Suggest you use the query designer to build then view query in SQL view.

Build the inner SELECT queries independently then copy/paste SQL into outer query to build all-in-one SQL.

Could provide your db for analysis.

[eugzl]

Hi June7. Thanks for reply.
If I understood correct I must create in my case three query and then join them. Is it correct?
Thanks.

[June7]

Use query builder to get the syntax correct. Inner queries can remain as separate objects that are referenced by outer query or if you want to combine into one SQL then copy/paste. Once it all works correct can delete the query objects.