select y.SNO from ( select * from T where subject='语文&(8803)#39; ) y join ( select * from T where subject='数学&(8804)#39; ) s on y.SNO =s.SNO where y.score>=60 and s.score <60; 这样可以吗?