SQL Query to select all the records

You are using the following MySQL query to select all records from tables Products and Sales.

SELECT *

FROM Products

XXX

ON Products.SalesID=Sales.SalesID;

What should be used in place of XXX to return records matching in both tables?

Options
  1. INNER JOIN Sales
  2. INNER JOIN SalesID
  3. INNER JOIN Sales.SalesID
  4. INNER JOIN Products

Related Posts