Find code and diagrams at: https://www.EliTheComputerGuy.com
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’;
