Here is my problem,
I made my own SQL table, nothing special here.
But... in that table, their are two members per row (member_id_1, member_id_2, don't ask me why, it is needed for my add-on ).
When I select that row, I would like to join xf_user so I can use rich usernames as an example, for both users.
My question ? How could I select my row and join xf_user on each of the two members id.
Thanks you very much for your help.