[SQL] Join

[whisher]

Ho provato così e sembra forse
funzionare ma vorrei qc input please !!!

SELECT t.id AS ticket_id, t.id_category AS category_id, t.id_user AS user_id, t.subject, t.content, u2.name, u2.surname, u2.email, t.submitted, t.status, c.name AS category_name
FROM tickets AS t
INNER JOIN categories AS c ON t.id_category = c.id
INNER JOIN users AS u ON u.id_workgroup = c.id_workgroup
INNER JOIN users AS u2 ON u2.id = t.id_user
WHERE u.id_workgroup = '8'