It’s sometimes difficult to know which SQL syntax to use when combining data that spans multiple tables. SQL provides ... An INNER JOIN will only return rows for which there is data in both tables.