MySQL – Table Joins Introduction (inner join)

Eli the Computer Guy MySQL Introduction (NEW)

Joining Tables allows you to interact with two tables as if they are one. This means you can simply reference a record from one table in another such as having a PART record reference a VENDOR ID.

select columns from table1 inner join table2 on table1.column=table2.column – Joins Table1 to Table2 on Columns
Example – select * from parts inner join vendors on parts.vendor_id=vendors.vendor_id;
Example – select part_name from parts inner join vendors on parts.vendor_id=vendors.vendor_id where vendor_name=’Mega Cog’;