左边加入访问 [英] Left Joins in access

问题描述

大家好，


我在访问中编写左连接查询时遇到了一些困难，下面是我在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 =''''）

解决方案

尝试使用括号。

不确定规则是什么，但Access喜欢括号

感谢您的回复，但我真的不知道从哪里开始，


非常感谢任何建议

当我做上述操作时我得到了缺少的操作员信息 - 请帮我拉我的头发

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

解决方案

Try using brackets.
Not sure what the rules are but Access likes brackets

thanks for the response, but i really haven''t a clue where to start,

any advice is greatly appreciated

when i do the above i get the missing operator message - please help i''m pulling my hair out

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