The following SQL statement uses a(n). SELECT P_CODE,P_DESCRIPT,P_PRICE,V_NAME FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
A)set operator
B)natural join
C)"oldstyle" join
D)procedural statement

Question

The following SQL statement uses a(n). SELECT P_CODE,P_DESCRIPT,P_PRICE,V_NAME FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
A)set operator
B)natural join
C)"old­style" join
D)procedural statement

Quizplus · Accepted Answer

The SQL statement uses an "old-style" join, which is indicated by the use of the WHERE clause to specify the join condition between the PRODUCT and VENDOR tables.

The Following SQL Statement Uses A(n)