SELECT A.NAME,B.SEX FROM AAA A,BBB B WHERE A.NAME=B.NAME
select bbb.sex from aaa inner join bbb on aaa.name=bbb.name
select aaa.name,bbb.sex from aaa left join bbb on aaa.name=bbb.name
SELECT A.NAME,B.SEX FROM AAA A,BBB B WHERE A.NAME=B.NAME
select a.name,b.sex from aaa a join bbb b on a.name = b.name
select sex from bbb where name in(select name from aaa)
select sex from aaa,bbb where aaa.name=bbb.nameorselect sex from aaa join bbb on aaa.name=bbb.nameor select sex from bbb where bbb.name in (select name from aaa)
select a.name,b.sex from aaa a join bbb b on a.name = b.name
where aaa.name=bbb.nameorselect sex from aaa join bbb
on aaa.name=bbb.nameor select sex from bbb
where bbb.name in (select name from aaa)