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