把一个表as成n个表。比如只有一个表member我可以这样 select a.x,b.x,c.x,d.x from member a,member b,member c,member d where a.id=b.id and b.id=c.id and c.id=d.id and d.id=a.id