MySQL – Table Joins Introduction (inner join)

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’;

Be the first to comment

Leave a Reply