combine three tables

[pala_jagadeesh]

How to combine as one table

I have three tables

table1:

product

apple;apple1;apple@

ball;ball@;ball@2

pen

table2:

Product1

apple

cap

pencil

table3:

product2

apple

chaco

pencil

I want output like below

All

apple;apple1;apple@

ball;ball@;ball@2

cap

chaco

pen

pencil

[Eugene_Sleator]

Hi @pala_jagadeesh  that question has been answered in this community post 

Combine-3-tables-into-1-by-Concatenate

hope this helps

[pala_jagadeesh]

@Eugene_Sleator 

Hi 

but in my table1 ,rows are separated by semicolon, 

only product apple is present in three tables

[BrunPierre · Accepted solution]

See attached.