試題詳解

2 select c_name, city from customer inner join sales using (s_id) where sales.lname = ‘Tom’; 下列那個 SQL 指令可和上述 SQL 指令得到相同的查詢結果？
(A) select c_name, city from customer inner join sales having customer.s_id =sales.s_id and sales.lname=‘Tom’;
(B) select c_name, city from customer where customer.s_id =sales.s_id and sales.lname=‘Tom’;
(C) select c_name, city from customer, sales where sales.lname=‘Tom’;
(D) select c_name, city from customer, sales where customer.s_id =sales.s_id and sales.lname=‘Tom’;