Merging data

[jaZZerkill]

I have two tables in one Access Database.

They both contain information about people with unique ID's.
Is it possible to create 1 table with all the information for every unique person?

Two difficulties:

1) In table one a unique person appears multiple times
2) There are more people in table 2 than in table 1. I only need the people that appear in both.



Example:

Table 1

Person	Day	Act1	Act2
A1	Monday	5	10
A1	Tuesday	5	15
A2	Monday	0	10
A2	Tuesday	15	15
B3	Monday	25	0
B3	Tuesday	5	0

Table 2

Person	Age	Sex
A1	22	M
A2	33	M
B1	44	M
B3	22	V
B4	23	M

Result

Persoon	Day	Act1	Act2	Age	Sex
A1	Monday	5	10	22	M
A1	Tuesday	5	15	22	M
A2	Monday	0	10	33	M
A2	Tuesday	15	15	33	M
B3	Monday	25	0	22	V
B3	Tuesday	5	0	22	V

Thx in advance

[Bob Fitz]

You can create a query:

SELECT Table1.Person, Table1.Day, Table1.Act1, Table1.Act2, Table2.Age, Table2.Sex
FROM Table1 LEFT JOIN Table2 ON Table1.Person = Table2.Person;