MySQL/NodeJS question

[acollierr17]

I'm accessing multiple tables in this database that stores punishment information. Each table I'm trying to access these rows of a specific player: uuid, reason, banned_by_uuid.

Now the farthest I got with any sort of query is this:

SELECT uuid, reason, banned_by_uuid FROM litebans_bans
        INNER JOIN litebans_mutes ON litebans_bans.uuid = litebans_mutes.uuid
        INNER JOIN litebans_kicks ON litebans_mutes.uuid = litebans_kicks.uuid
        INNER JOIN litebans_warnings ON litebans_kicks.uuid = litebans_warnings.uuid;

Try in some way to inner join the tables to create a new one where I can see the overall punishment history of a user. The syntax I'm using isn't probably even correct (as some of the fields are ambiguous).

A friend of mine tried who is savvier with Java than Js, but he wasn't able to make much progress on this either. Any help with this would be appreciated. If more explanation is needed, simply ask.