Append 2 files

[Guest]

I have 2 files each with the same fields that I'm just trying to append to
each other. For example:

File1
id age
1 10
2 20
3 30

File2
id age
4 40
5 50
6 60

And I want:
id age
1 10
2 20
3 30
4 40
5 50
6 60

Can I do this in SQL?

 

[pietlinden]

I have 2 files each with the same fields that I'm just trying to append to
each other. For example:

File1
id age
1 10
2 20
3 30

File2
id age
4 40
5 50
6 60

And I want:
id age
1 10
2 20
3 30
4 40
5 50
6 60

Can I do this in SQL?

two files or two tables?
You can use a union query

SELECT id, age
FROM table1
UNION ALL
SELECT id, age
FROM table2
ORDER BY id, age;

if the field names do not match, you need to alias them

SELECT idno AS id, age
FROM table1
WHERE...
UNION ALL
SELECT id, age
FROM table2
ORDER BY id, age;

 

[Jerry Porter]

David,

If you want to actually append the data from one table into the other,
use an Append query. This is easy to do from the Query screen. The SQL
would look something like:

Insert Into Table1 (id, age) Select id, age from Table 2

If id is an AutoNumber field, then don't include it in the query.

Jerry

 

[James A. Fortune]

I have 2 files each with the same fields that I'm just trying to append to
each other. For example:

File1
id age

If you have an age field it needs to be constantly updated. It's better
to obtain the birthdate, enter it once, then calculate age as needed.
Look up "birthday" in this NG for various calculation methods.

James A. Fortune
(e-mail address removed)