How to merge two database using Base?

Database 1 Contains:
John Smith

Database 2 contains:
john smith | likes cookies

What is the simplest way of merging these two databases using Base?

Output should be =
John Smith | likes cookies

Thank you.

Hi

You do not give enough detail to get an answer:

  • Are the data in different databases (.odb) or tables in the same database?
  • Database 2: are the data in separate fields or in the same field with the separator |?
  • Do you desire the result in a single field with separator or two fields?
  • The names that appear in a database, they all appear in the other base?

Regards