Re: Data from 2 tables

[Peter Brawley]

Including name.id values in the sex table is incorrect, you want ...

name(
  id int unsigned primary key auto_increment,
  firstname varchar(32),
  lastname varchar(32),
  sexid tinyint unsigned
) 

sex(
  id unsigned tinyint unsigned primary key, 
  name char(6) 
) 
with rows (1,'male'), (2, 'female'), (3, 'other')

... then a query for 'smith' males is ...

select n.lastname, s.name
from names n
join sex s on n.sexid=s.id
where n.last='smith';

Read about normalisation, then about joins.