Consider the following question, and list the tables and fields needed to answer them. Indicate whether the join should be a left, right, or inner join.

Are there purchases made from vendors that are not in the Vendor table?

Table

Join type