Re: help with a simple query problem SQL

[timb]

Have you tried a union query? Something like the following should work.

SELECT module.ModuleCode, module.Title, module.Semester,module.StaffID_1, staff.name, staff.Email
FROM module
INNER JOIN staff ON module.StaffID_1 = staff.staffID'
UNION
SELECT module.ModuleCode, module.Title, module.Semester,module.StaffID_2, staff.name, staff.Email
FROM module
INNER JOIN staff ON module.StaffID_2 = staff.staffID';