How many JOINS are possible?

General Discussions - English
1

Hi.
How many JOIN statements can i have in my SELECT query?
Can i add aliases for tables?

From given example i see that i need to:

  • write only second table name in SELECT
  • write table names in ON part of query
  • write only second table name in WHERE, ORDER BY, GROUP BY

Is that correct?

2

Only one

Is that correct?

Yes, it seems so. You can find the JOIN caveats listed here: Searching > Joining | Manticore Search Manual

3

Is there a plan to support multiple joins in future releases?

4

This is not in our immediate plans. As far as I know, there is no open issue for this yet. Feel free to create a feature request.