Append new record

D

D

Hi:

I have two tables: T1 and T2 joined by Store #; I want to compare the T1 and
T2; when T2 has a new record = new store, I want to append the record to T1:

How do I do that?

Thanks,

Dan
 
D

Douglas J Steele

Why? As in why do you want to have duplicated data? It's seldom (if ever) a
good thing to do.
 
D

D

Hi Douglas:

Because T1 has more info than T2; again the common field is Store #.

Thanks,

Dan
 
D

Douglas J. Steele

That doesn't sound like a good design. Each piece of data should exist in
just one table, rather than duplicating certain pieces of data across
multiple tables.
 
Top