I was wondering if anyone could show me a data dump and a valid example of using JOIN

I wanted to see if I could use it to retrieve the sakt and use CONCAT and MD5 to hash up my passwords for loggin in.