Moving on. What if I wanted to pull a list of suppliers along with the products they supply. This data exists in multiple tables so we'll need to write a query to pull FROM more than one table. To do this we have to "join" tables using the JOIN syntax. This allows you to join tables and pull fields from multiple tables. The syntax to do this changes only slightly from what you know. Instead of selecting FROM one table you will select from a "join" between two tables. How do we connect tables? Q7 on Google Form: What is the name for a field used to relate tables in a database? 16. Select * from the Suppliers table and note in your google form what the primary key of the table is. Q8 on Google Form: What field is the primary key field on Suppliers table? 17. Select *from the Products table and note in your google form what the primary key of the table is. Q9 on Google Form: What field is the primary key field of Products table? Q10 on Google Form: What is the foreign key field on the Products table that links you to the Suppliers table