SQL 如何 查询 子表数据 1对多关系!

Question

比方说:
表a (id,name) -id =PK
表b (id,sex,age) -id=FK

根据想查出a表中 刘明这个人的信息!(sex,age)
怎么写SQL?

Answer 1

select name,sex,age from 表a,表b where 表a.id = 表b.id and name = '刘明'

Answer 2

SELECT NAME,SEX,AGE
FROM 表A A
JOIN 表B B
ON A.ID=B.ID
WHERE A.NAME='刘明'

Answer 3

select A.name,B.sex,B.age from 表a A,表b B where A.id = B.id and A.name = '刘明' GROUP BY A.name,B.sex,B.age

Answer 4

select age,sex from 表b where id in(select id from 表a where name='刘明')

Answer 5

a表和b表有什么关系的??...a表的ID=PK,b表的ID=FK,能说的明白点吗???