MySQL - JOIN

"users" table:

user_id	name	city	age
1	Pauline jameson	New York	15
2	Jimmy McNulty	Los Angeles	44
2	Andrew Wilkins	Chicago	15
2	Bob Seizmore	New York	16

"user_gender" table:

gender	user_id
female	1
male	2
male	3
male	4

SELECT users.name,user_gender.gender FROM users,user_gender
WHERE users.user_id = user_gender.user_id;

Result:

name	gender
Pauline jameson	female
Jimmy McNulty	male
Andrew Wilkins	male
Bob Seizmore	male