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

Example
Drmo Tables

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;