1) Using a subquery, check to make sure each product supplier ID (foreign key) is also listed as a primary key in the Supplier table. (This is a referential integrity check). Once that is done, list all customers who have purchased tool items. Include the customer's ID, customer's last name, first name, state, the product, supplier of the product, and product category of each purchase. USE A JOIN. This will result in two separate queries and results!
Attachment:- Tables.xlsx