Question

Suppose that a PRODUCT table contains two attributes, PROD_CODE and VEND_CODE. Those two attributes have values of ABC, 125, DEF, 124, GHI, 124, and JKL, 123, respectively. The VENDOR table contains a single attribute, VEND_CODE, with values 123, 124, 125, and 126, respectively. (The VEND_CODE attribute in the PRODUCT table is a foreign key to the VEND_CODE in the VENDOR table.) Given that information, what would be the query output for:
a. A UNION query based on these two tables?
b. A UNION ALL query based on these two tables?
c. An INTERSECT query based on these two tables?
d. A MINUS query based on these two tables?



$1.99
Sales0
Views82
Comments0
  • CreatedDecember 03, 2014
  • Files Included
Post your question
5000