这样SQL语句如何在连接一个表读取其中字段的值。

ysf0181 发布于 2010-07-26 17:29， 830 次点击

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 编辑 ]

4 回复

ysf01812010-07-26 17:52

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%

ysf01812010-07-26 20:42

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

gupiao1752010-07-27 00:53

ysf0181

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

ysf01812010-07-27 09:18

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

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