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]));