INNER JOIN

INNER JOIN return rows when there is at least one match in both tables.

Syntax

SELECT columnA, ... columnX

FROM table1

INNER JOIN table2

ON table1.columnA = table2.columnA

Example

SELECT products.ProductName, products.ProductID

FROM /shared/examples/ds_inventory/products products

INNER JOIN /shared/examples/ds_inventory/products products_1 

ON products.ProductID = products_1.ProductID