Which SQL statement would join the tables on product number (prod#) and provide a table of what products (product), if any, the parts (part) are used?

Given the tables:

Which SQL statement would join the tables on product number (prod#) and provide a table of what products (product), if any, the parts (part) are used? Limit the result to only parts where suppliers (supplier) do not start with the letter A.

A.

B.

C.

D.

Answer: A

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments