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