SQL Query in Access

[DaveyJ]

Hi Guys,

I'm having a few difficulties writing a left join query in access, below is what i've done in SQL but having a few problems getting the same result from access , any help is much appreciated.


SELECT tbl_employee_details.SOEID, tbl_employee_details.FirstName, tbl_employee_details.Surname, tbl_requests.RequestID,
tbl_Software_types.SoftwareName, tbl_hardware_types.HardwareTypes

FROM tbl_requests INNER JOIN



tbl_employee_details ON tbl_requests.SOEID = tbl_employee_details.SOEID LEFT JOIN

tbl_software_requests ON tbl_requests.RequestID = tbl_software_requests.RequestID LEFT JOIN
tbl_Software_types ON tbl_software_requests.ApplicationName = tbl_Software_types.ApplicationTypeID LEFT JOIN
tbl_hardware_requests ON tbl_requests.RequestID = tbl_hardware_requests.RequestID LEFT JOIN
tbl_hardware_types ON tbl_hardware_requests.HardwareType = tbl_hardware_types.HardwareTypeID


WHERE (tbl_employee_details.SOEID = '')

[DaveyJ]

i get the following error when writing in MS Access

The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement. (Error 3258)

Really need help writing this query