我已经阅读了MySQL 5中的61 table join limit,但我不确定它将如何适用于以下内容:
SELECT * FROM (
SELECT * FROM tableA JOIN // Lots of other joins here...
UNION
SELECT * FROM tableB JOIN // Lots of other joins here...
UNION
SELECT * FROM tableC JOIN // Lots of other joins here...
// etc...
)
我是否会在所有子查询中共有61个表,或者每个UNIONed子查询是61个?
这是否因DB而异,例如Postgresql,MSsql,Oracle?
@H_301_13@