Merging 2 tables

[filterjon]

Hello,

I want to merge 2 tables to simplify a database.

I wish to add into the first table some text from the 2nd table where an ID matches. But I don't want to append new rows or columns I wish to add the text into an existing text box on the record.

e.g>
Table 1
ID Name
1 Jon

Table 2
ID Surname
1 Lock

goes to

Table 1
ID Name
1 Jon Lock

Is this possible?

Thanks in advance. Jon

 

[lespaul]

I would just do this in the query anytime I needed the information combined:

SELECT A.ID, A.Name & " " & B.Name
FROM Table1 A
INNER JOIN Table2 B ON A.ID = B.ID

If you really want to do the update then maybe something like:

UPDATE Table1 A INNER JOIN Table2 B ON A.ID = B.ID SET A.Name = A.Name & " " & B.Name

disclaimer: all queries typed not tested


Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[filterjon]

Thanks Leslie - I will have a play with the set bit of the inner join.

p.s. I love your disclaimer!!!!