Exam4Training

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

Exit mobile version