这样SQL语句如何在连接一个表读取其中字段的值。
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中
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
