MySQL - Table Joins Introduction (inner join)

MySQL - Table Joins Introduction (inner join)

Find code and diagrams at: https://ift.tt/2zY82iQ 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’;

View on YouTube