Basically have two tables like

user table-"u"

userid | name
 1     |  lenova
 2     |  acer
 3     |  hp

pass table-"p"

userid | password
 1     | len123
 2     | acer123
 3     | hp123

for when i learnt from lessons I'm able to join these 2 tables using many joins obtainable in mysql as stated here

If i've got a table like

role table-"r"

roleid | rname
 1     | admin
 2     | user
 3     | dataanalyst

token table-"t"

tokenid| tname
 1     | xxxx
 2     | yyyy
 3     | zzzz

tole_token_association table-"a"

roleid | tokenid
 1     |  1
 1     |  2
 3     |  1
 3     |  3
 3     |  1

I must create a join so that I must display a table which corresponds such as this "rolename" has each one of these tokens.Steps to make this? I'm confused. Can you really create a join? I'm liking mysql a great deal. If only to experience with queries so that not playing. I wish to get better experienced. Any Suggestions Please?

It's simplest to determine once the column names that should be became a member of are named in the same way:

SELECT r.rname,
       t.tname
  FROM ROLE r
  JOIN ROLE_TOKEN_ASSOCIATION rta ON rta.roleid = r.roleid
  JOIN TOKEN t ON t.tokenid = rta.tokenid

This can return just the roles with tokens connected. For those who have a job that does not possess a token connected, you should utilize an OUTER join, such as this:

   SELECT r.rname,
          t.tname
     FROM ROLE r
LEFT JOIN ROLE_TOKEN_ASSOCIATION rta ON rta.roleid = r.roleid
     JOIN TOKEN t ON t.tokenid = rta.tokenid

This link might help -- it's a visual representation of JOINs.