On Tue, 15 Aug 2000, Sandis wrote:
> there is a db with a few tables that have related (joined) fields. if
> record in a one table (auxiliary) gets deleted (along with it's
I would say this is the primary table.
> primary key), reference to it in another table (main) points to
And this is the secondary tab,le which references the other.
> what's the solution? should i check if this 'project', for example,
The solution is called referential integrity. you should use the foreign
key and references clause with cascade.
> can someone suggest some good online resource where such common sql topics
> discussed?
I would like to know such a place.
Jesus.