其中 A, B, C 為欄位名稱,1~4, a~c, x~z 為欄位的值,請寫出下列 SQL 查詢結果:
申論題內容
(一)SELECT * FROM R NATURAL JOIN S;
詳解 (共 3 筆)
詳解提供者:王承漢
A B C
---------
b 2 x
c 3 y
詳解提供者:骨粗雞
A B C
____________________
b 2 x
c 3 y
詳解提供者:傑
SELECT A, R.B, C FROM R RIGHT OUTER JOIN S ON R.B = S.B;
SELECT A, R.B, C FROM R RIGHT OUTER JOIN S ON R.B = S.B;SELECT A, R.B, C FROM R RIGHT OUTER JOIN S ON R.B = S.B;ggg