求教一个SQL的语法的写法

[turbochen]

A表：
id name
1 chenxu
2 wanghai
3 xiehua

B表:
id property value
1 sex M
1 age 20
2 sex F
2 age 25
3 sex M
3 age 18

请问我要找出所有sex为M,年龄>=20的人，SQL语法该如何写?

[奇遇]

test as:
select name from A where id in (select id from B where sex='M') and id in (select id from B where age >=20)

[qqqdong]

select * from a表 where id in (select id from b表 where (property = 'sex' and value = 'M')
or (property = 'age' and value >= '20') group by id having count(*) >= 2)

[昵称被占用了]

呵呵,这个设计有意思!

SELECT A.* FROM A,B B1,B B2
WHERE A.ID=B1.ID
AND B1.property='SEX' AND B1.value='M'
AND A,ID=B2.ID
AND B2.property='AGE' AND CAST(B2value AS INT)>=20

[turbochen]

thanks to Haiwer(海阔天空),佻的方法最有效。
各人接分了。