There are 2 tables:
and users_information:In the photo I have inserted all the fields of the table. Also in the tables there are foreign keys on the table, but for understanding challenges it does not matter.The bottom line:
I'm trying to do a query that would return something like this:
That is, I want to know the name and the name of the person who sent the message and the name of the one who received the message.