Q1
Single choice
Given the following two tables:
TAB1
----------------------
COL_1 COL_2
----- -----
A 10
B 12
C 14
TAB2
----------------------
COL_A COL_B
----- -----
A 21
C 23
D 25
Assuming the following results are desired:
COL_1 COL_2 COL_A COL_B
A 10 A 21
B 12 - -
C 14 C 23
- - D 25
Which of the following joins will produce the desired results?