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’;

答案:登入後查看
統計: A(15), B(40), C(29), D(96), E(0) #2053043

詳解 (共 1 筆)

#3717872
inner join = ANDusin...
(共 52 字,隱藏中)
前往觀看
1
0