I have problem with my query and i can not figure it how to do it. What i want to do is to display “Ban By” name to table. I know how to join two tables and that is what i did here:
x
SELECT reason, expired, created, actor_id, name
FROM bm_player_ban_records
LEFT JOIN bm_players ON bm_player_ban_records.player_id = bm_players.id
WHERE bm_players.name = 'NexoR'
but i need to join the same tables again and now i need to pair them by actor_id to id and than display name and this is where my brain stopped and do not know how to do it. https://imgur.com/a/uW7jznk <- images
Advertisement
Answer
SELECT
reason,
expired,
created,
actor_id,
name
FROM
bm_player_ban_records
LEFT JOIN
bm_players AS BAN_by ON Ban_by.id = bm_player_ban_records.player_id
LEFT JOIN
bm_players AS ACTORE ON ACTORE.id = bm_player_ban_records.actor_id
WHERE
Ban_by.name = 'NexoR'
you will likely need to prefix the fields in the SELECT with the correct alias for the table