select * from (select c.idinfo,c.nameinfo,c.artinfo,c.timeinfo,c.tid,c.class,c.major from info b inner join (select tid ,tname from ts where sid = 222221)as a on b.tid = a.tid ) as c inner join ( select max(idinfo),tid from info group by (tid) ) as d on c.tid = d.tid;
语法哪错了,完全查不出,求大神指导select *from (select c.idinfo,c.nameinfo,c.artinfo,c.timeinfo,c.tid,c.class,c.majorfrom info b inner join(select tid ,tnamefrom ts where sid = 222221)as aon b.tid = a.tid) as c...