select [renkeanpai].id,kecheng,xueqixueshi,shiyanxueshi,zhouxueshi,shizhongzhou,kaohetype,jiaoshi,banji,jiaoxuetype,duomeiti from [renkeanpai],[time1],[jiaoxuetype],[banji] where [renkeanpai].timeid=[time1].id and [renkeanpai].banjiid=[banji].id and [renkeanpai].jiaoxuetypeid=[jiaoxuetype].id where timeid="4"order by [renkeanpai].id asc