select bianhao,xueyuan,id from jiaoyuanclass where id in (select max(id) from jiaoyuanclass group by xueyuan) order by id desc

在读取  表：person  字段：zcishu 中的值，，，，是以  xueyuan 的值来传到给 相等 表person中字段zcishu中




[ 本帖最后由 ysf0181 于 2010-7-26 17:53 编辑 ]

select e.bianhao,e.xueyuan,d.zcishu from jiaoyuanclass where id in (select max(id) from jiaoyuanclass group by xueyuan) as e inner join person as d on e.xueyuan=d.name

这样 CPU  100%

select * from table1,table2 where table2.id in (
select max(id) from table2 group by name) and table1.name
=table2.name;

select * from person,jiaoyuanclass where jiaoyuanclass.id in(select max(id) from jiaoyuanclass group by xueyuan) and person.name=jiaoyuanclass.xueyuan

ysf0181，你的问题不简单啊，没有时间研究了，要睡觉了。如果急的话，可以转发到SQL版块去，那里搞SQL的人多些！

select person.name,person.zcishu,jiaoyuanclass.xueyuan,jiaoyuanclass.bianhao from person,jiaoyuanclass where jiaoyuanclass.id in(select max(id) from jiaoyuanclass group by xueyuan) and person.name=jiaoyuanclass.xueyuan

自己搞定了。呵呵，谢谢。