MySQL INNER JOIN

Last Updated: March 14, 2022

MySQL INNER JOIN keyword matches the rows on both tables that have matching values on both tables

INNER JOIN Syntax

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;

The following Venn diagram show how INNER JOIN works

inner join venn

Example

Drmo Tables

product vendors

The following query will list all records with product name

SELECT products.product_name, vendors.vendor_name
FROM products
INNER JOIN vendors ON products.vendor_code = vendors.vendor_code;
Test