問題詳情
14. 附圖有兩個資料表分別為 Table1、Table2，今想將兩資料表合併、並顯示出 Name、Sales、Store 3 個欄位，請問下列何者為正確 SQL 語 法？
(A) SELECT T1.Name, T2.Sales, T2.Store FROM Table1 as T1, Table2 as T2 WHERE T1.Name = T2.Name；
(B) SELECT T1 Name, T1 Sales, T2 Store FROM Table1 as T1, Table2 as T2 WHERE T1.Name = T2.Name；
(C) SELECT Name, Sales, Store FROM Table1, Table2 WHERE Name = Name；
(D) SELECT T1.Name, T1.Sales, T2.Store FROM Table1 as T1, Table2 as T2 WHERE T1.Name = T2.Name；
參考答案
答案：D
統計：A:0,B:2,C:0,D:4,E:0
難度：計算中