問題詳情

37. Consider the following tables, A and B, in a relational database:


 Which of the following SQL statement can be used to concatenate A and B?
(A) SELECT * FROM A UNION ALL SELECT * FROM B
(B) SELECT * FROM A FULL OUTER JOIN B ON A.id = B.id
(C) SELECT * FROM A INNER JOIN B ON A.id = B.id
(D)SELECT * FROM A LEFT JOIN B ON A.id = B.id

參考答案

答案：[無官方正解]
難度：計算中-1
書單：沒有書單，新增