表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 作者: 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.mangerid .......作者: 剑雨飘扬 时间: 2015-3-25 15:01
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 ...