Skip to content
Advertisement

Join same two tables multiple times in one query [closed]

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:

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

you will likely need to prefix the fields in the SELECT with the correct alias for the table

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement