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

詳解 (共 1 筆)

#6971331
1. 題目解析 本題要求合併兩個資料表...
(共 935 字,隱藏中)
前往觀看
0
0