Consider the two tables below:
Table_A
Col1 Col2 Col3
001 Null Null
002 Null Null
003 Null Null
004 Null Null
005 Null Null
Table_B
Col1 Col2 Col3
Null yes Ife
Null No Titi
Null Yes Tolu
Null Yes Bass
Null No Tom
How can I write an SQL code to Merge the two tables to produce a new table called Table_C
as shown below?
Table_C
Col1 Col2 Col3
001 yes Ife
002 No Titi
003 Yes Tolu
004 Yes Bass
005 No Tom
Thanks.
