Witam

Mam tabele
1 - 'events' i kolumny event_id, user_id, soundsupport_id, techsupport_id
2 - 'workers' i kolumny user_id, user_name, user_email

pobieram sobie jeden event z tabeli i mam problem z dopasowaniem ludzi z tabeli workers
bez problemu pobieram sobie pracownika ktory dodal event

SELECT * FROM events
INNER JOIN workers ON events.user_id = workers.user_id
WHERE event_id='1'

Czy da się w tym zapytaniu przyporządkować nazwę pracownika(user_name) dla kolumn soundsupport_id i techsupport_id

Pozdrawiam

SELECT * FROM events
INNER JOIN workers ON events.user_id = workers.user_id
INNER JOIN workers AS w2 ON events.soundsupport_id = w2.id
...itd
WHERE event_id='1'

SELECT [to co chesz] FROM events
left JOIN workers usign(events.user_id)

WHERE event_id='1'