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;
答案:登入後查看
統計: A(0), B(2), C(0), D(7), E(0) #3219248
統計: A(0), B(2), C(0), D(7), E(0) #3219248