How to make a mysql query from two tables, but not quite simple?

Question

MySQL

There are two tables: event and command
in event the id of two teams is entered
.
I did it through joins, but I could only display the name of one command, and for the second I don’t understand how to do it.

Answer 1

Second JOIN with the same instruction table, only with a different alias (AS) and by a different key.

Answer 2

And you tell me how you want to get the answer, give an example of the result