t****y 发帖数: 576 | 1 I think the correct answer should be d.
Complete the following PROC SQL query to select the columns Address and
SqFeet from the table List.Size and to select Price from the table List.
Price. (Only the Address column appears in both tables.)
proc sql;
_____________
from list.size,list.price;
a. select address,sqfeet,price
b. select size.address,sqfeet,price
c. select price.address,sqfeet,price
d. either b or c
Correct answer: b
Your answer: undefined
The SELECT clause lists the columns from both tables to be queried. You must
use a prefix with the Address column because it appears in both tables. The
prefix specifies the table from which you want the column to be read. |
|