左边加入访问

问题描述

大家好，


我在访问中编写左连接查询时遇到了一些困难，下面是我在SQL中所做的但是遇到了一些问题来自访问的相同结果，非常感谢任何帮助。


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.HardwareT ype = tbl_hardware_types.HardwareTypeID


WHERE（tbl_employee_details.SOEID =''''）

解决方案

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 = '''')

解决方案

这篇关于左边加入访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！