单项选择题
A.select p.prod_id,p.prod_name,b.box_loc from product p,storage_box b where p.prod_id =b.prod_id and prod_name=’WIDGET’;
B.select p.prod_id,p.prod_name,b.box_loc from product p,storage_box b where prod_name=’WIDGET’;
C.select p.prod_id,p.prod_name,b.box_loc from product p,storage_box b where p.stor_box_num =b.stor_box_num and prod_name=’WIDGET’;
D.select prod_id,prod_name,box_loc from product ,storage_box where stor_box_num =stor_box_num and prod_name=’WIDGET’;