The conversation between human and AI assistant.
What is the difference between Cross Join and Inner Join in MySQL?
Can you give an example of Inner join?
Sure, let's say you have two tables: 'Customers' and 'Orders'. You can use Inner join to combine only the data from rows that have matching values in a specific column, for example 'customer_id'. The SQL code for Inner join might look something like this: 

SELECT Customers.name, Orders.order_number 
FROM Customers
INNER JOIN Orders
ON Customers.customer_id = Orders.customer_id;