- 搜標題
- 搜題干
- 搜選項
單項選擇題
Given the following two tables:
TAB1 C1 C2
A 11 B 12 C 13 TAB2 CX CY
A 21 C 22 D 23
The following results are desired:
C1 C2 CX CY
A 11 A 21 C 13 C 22 -- --D 23
Which of the following queries will yield the desired results?（）
A.SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
B.SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
C.SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
D.SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
你可能感興趣的試題
