I'm trying to work out a SQL problem and found myself stuck so hoping someone can assist. Based on the attached document, I have created three tables and inserted vendors into the vendor table. But I am not understanding how to get the data in part 3 into the vendor product table.
Would greatly appreciate any assistance as I am just learning SQL.
Since the vendorproduct table has foreign key references to the vendor and product table, you need to insert the correct rows in there first. Once you've done that you need to insert the correct productid and vendorid values into the vendorproduct table.