Concatenate tables

[govindvasu]

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?

[BrunPierre · Accepted solution]

Exactly! Because concatenation preserves all the rows from both tables, even if the columns have duplicate values.