为webapp加入多个表

I have 10 tables of player statistics and I would like to JOIN them all so I can display a statistic leaders table in my web application. I am new to this and I know a JOIN would work for two tables but is there a way of joining 10 tables?

我有10个玩家统计表,我想加入所有这些,所以我可以在我的网络应用程序中显示统计领导者表。我是新手,我知道JOIN可以用于两个表,但有没有办法加入10个表?

Thanks

1 个解决方案

#1

Is it possible? Yes... But its a very expensive query to call and you should try to limit the amount of joins

可能吗?是的......但它是一个非常昂贵的查询调用,你应该尝试限制连接数量