INNER JOIN
INNER JOINは、両方のテーブルに少なくとも1つの一致がある場合に行を返します。
構文
SELECT columnA, ... columnX
FROM table1
INNER JOIN table2
ON table1.columnA = table2.columnA
例
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