Query Brings back duplicate results

[DaveyJ]

Hi Guys,

Having a problem with a query.. Basicly i want the query to bring back results from 3 tables to show all requests that have been made for an employee , search by employee ID (SOEID)

the results bring back the results but duplicated many times (3)



some advice is needed to where i have went wrong.

Sql code below


SELECT
tbl_application_names.SoftwareName,
tbl_software_requests.SoftwareRequestNumber, tbl_hardware_requests.HardwareType, tbl_hardware_requests.HardwareRequestNumber, tbl_software_requests.SOEID

FROM

tbl_hardware_types INNER JOIN ((tbl_employee_details INNER JOIN tbl_hardware_requests ON tbl_employee_details.SOEID = tbl_hardware_requests.SOEID) INNER JOIN (tbl_application_names INNER JOIN tbl_software_requests ON tbl_application_names.ApplicationNameID = tbl_software_requests.ApplicationName) ON tbl_employee_details.SOEID = tbl_software_requests.SOEID) ON tbl_hardware_types.HardwareTypeID = tbl_hardware_requests.HardwareType

WHERE
(((tbl_software_requests.SOEID)=[Enter SOEID]));

[llkhoutx]

You have multiple records on the left or right table, you have to figure out which.