In general, if you want to join tables then you have to have some column in common between the tables. See
SQL Joins Explained[
^]
In your case you have no columns in common so the only join you can have is a cross-join -
SQL Cross Join[
^]
select * from [Name], [Type]
To fix this, your table structures should be
Name-fields(username,age,genderid)
Type-fields(genderid, gender)
E.g.
UserName GenderId
username1 1
username2 2
username3 1
GenderId Gender
1 Female
2 Male
and you can then use something like this
select username, age, gender
from [Name] N
left join [Type] T ON N.genderid=T.genderid