select a.sid, a.栏位1, a.栏位2,.....,b.栏位1,b.栏位2,..... from a inner join b on a.sid=b.sid order by a.sid desc
select * from a,b where a.sid=b.sid order by a.sid asc
