SELECT *
FROM talent, education
WHERE academic
IN (
SELECT academic
FROM education
WHERE Uid =26 order by academic desc limit 1) AND talent.id = education.uid
FROM talent, education
WHERE academic
IN (
SELECT academic
FROM education
WHERE Uid =26 order by academic desc limit 1) AND talent.id = education.uid
select * from talent,education where talent.ID = education.Uid and talent.ID = '26' order by education.academic desc limit 1;
Id=5,name="张三"
education里有对应张三这个人的三条记录
Id=1 Uid=5 academic=4
Id=2 Uid=5 academic=5
Id=3 Uid=5 academic=6那如果我查 academic=6的确可以查出张三这条记录出来,问题在于,如果查academic=5,张三这个人一样也会出来
这是学历的话,就麻烦了,查个本科的,把博士查出来了,人家养不起\的啊
Id=5,name="张三"education里有对应张三这个人的三条记录
Id=1 Uid=5 academic=4
Id=2 Uid=5 academic=5
Id=3 Uid=5 academic=6那如果我查 academic=6的确可以查出张三这条记录出来,问题在于,如果查academic=5,张三这个人一样也会出来
这是学历的话,就麻烦了,查个本科的,把博士查出来了,人家养不起\的啊
谁让你用低版本的mysql呢,mysql4.1就开始支持子查询了