写一个查询,有二个表aaa有一字段(name),bbb有二字段(name,sex),我要查询aaa的列表

[bobozc]

写一个查询,有二个表aaa有一字段(name),bbb有二字段(name,sex),我要查询aaa表中的name和于aaa中的name相等的bbb表中的sex

[hjb111]

select bbb.* from aaa,bbb where aaa.name=bbb.name

[commanddos]

SELECT A.NAME,B.SEX FROM AAA A,BBB B WHERE A.NAME=B.NAME

[雨后阳光2000]

select bbb.sex from aaa inner join bbb on aaa.name=bbb.name

[CrazyFor]

select aaa.name,bbb.sex from aaa left join bbb on aaa.name=bbb.name

[haozhiyuan2003]

SELECT A.NAME,B.SEX FROM AAA A,BBB B WHERE A.NAME=B.NAME

[txlicenhe]

select a.name,b.sex from aaa a join bbb b on a.name = b.name

[zjcxc]

select sex from bbb where name in(select name from aaa)

[z5wjz]

select sex from aaa,bbb
where aaa.name=bbb.name

or

select sex from aaa join bbb
on aaa.name=bbb.name

or

select sex from bbb
where bbb.name in (select name from aaa)

[happy_0325]

select a.name,b.sex from aaa a join bbb b on a.name = b.name