Lets us say for example you've the following

Table members
`id`
`username`
`password`

Table info
`info1`
`info2`
`user_id`

What would be a JOIN statement between the two? (I've looked at the examples on mysql and can't understand)

Ultimately I'd like to in the query fetch the hash from the row and concat it with the password and then md5 it.