The conversation between human and AI assistant.
What is the difference between Cross Join and Inner Join in MySQL?
That's helpful. Can I use Inner join on more than two tables?
Yes, you can use Inner join to combine data from any number of tables, as long as they have matching values in the specified columns. The SQL syntax would look something like this:

SELECT *
FROM table1
INNER JOIN table2
ON table1.column = table2.column
INNER JOIN table3
ON table2.column = table3.column;