Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two tables and i have to concatenate them
TableA
emp_id Name age
1 John 32
2 smith 25
TableB
emp_id Name age
1 John 30
2 Kim 25
what would be my resultant table. Will it show the John two time with different ages?
Exactly! Because concatenation preserves all the rows from both tables, even if the columns have duplicate values.
Exactly! Because concatenation preserves all the rows from both tables, even if the columns have duplicate values.