Code: Select all
SELECT
rp.id_primary AS `ID`,
rp.number AS `Rpi Number`,
rp.revision AS `Revision`,
CONCAT_WS(' ', sp.first_name, sp.last_name) AS `Originated by`,
CONCAT_WS(' ', sp.first_name, sp.last_name) AS `Approved by`,
CONCAT_WS(' ', sp.first_name, sp.last_name) AS `Revised By`
FROM
rpi_procedures AS rp,
system_profiles AS sp
WHERE
sp.id_user IN (rp.id_originated, rp.id_approved, rp.id_revised)
AND
(rp.id_status = 1 AND rp.id_task = 0)
I have it wrong but don't think I am far off. Maybe use a sub-select somehow to lookup the ID's