help with 3 tables [message #21028] |
Mon, 08 July 2002 04:45 |
a
Messages: 22 Registered: March 2002
|
Junior Member |
|
|
How would I find the differences between three tables.. For example
T1 is a table of names (lastname as the primary key) T2 is a table of ages, birthdays, addresses..etc (Ages and Lastnames as the primary keys)
T3 is a table of presents per age (Age as the primary key)
so (T1.lastname = T2.Lastname AND T2.Age = T3.Age)
How do I find out if one
entry has been added or deleted from any of these tables?
|
|
|
Re: help with 3 tables [message #21050 is a reply to message #21028] |
Tue, 09 July 2002 06:25 |
AYSEGUL
Messages: 4 Registered: July 2002
|
Junior Member |
|
|
you can do a trigger
when table updated or inserted time will be run .
and you must create a different another table and
someone adds a data this tables your other table will be update.
|
|
|