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?

A.
SELECT * FROM tab1 INNER JOIN tab2 ON col_1 =col_a

B.
SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON col_1 =col_a

C.
SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON col_1 =col_a

D.
SELECT * FROM tab1 FULL OUTER JOIN tab2 ON col_1 =col_a