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