Re: Question

> Hello Christopher,
>
>   I don't need delete record from jobs when I delete record from
>   activity. But I need delete record from activity when I delete the
>   record from jobs and I need to find this job_id in activities table!
>   What must I do?
>
> CKL> Question: Why don't you just set up a foreign key that will
> achieve exactly
> CKL> the same thing without using RULEs?
>
> CKL> ie. ALTER TABLE activities ADD FOREIGN KEY (job_id)
> REFERENCES jobs(job_id)
> CKL> ON DELETE CASCADE;

My ALTER TABLE statement above will do exactly this.

It will delete activities when a job is deleted.  Try it in a test database.

Chris