表Test有4个属性 ID NAME AGE MANAGER(ID),怎样查出AGE比所属MANAGER大的人的ID和NAME？select ID, NAME from Test as a where AGE>(select AGE from Test as b where a.MANAGER=b.ID);
这样好像不行。


用join方法把两个表连起来就可以查了，select t1.name,t1.id from test as t1 join test as t2 on t1.manager=t2.id and t1.age>t2.age

select t1.name,t1.id from Test as t1 join Test as t2 on t1.id = t2.mannagerid where t1.age > t2.mangerid .......

ruchsky 发表于 2015-3-25 14:43
select t1.name,t1.id from Test as t1 join Test as t2 on t1.id = t2.mannagerid where t1.age > t2.mang ...

我试了一下，得t1.managerid=t2.id才行。