🚀 go-pugleaf

Paul, take a look at foreign key constraints.  If the constraints are 
defined properly (ON DELETE CASCADE), then the child records are deleted 
automatically when the parent record is deleted.

Dan

"esnpe" <esnpe@hotmail.co.uk> wrote in message 
news:Xns9931714AB38D3esnpehotmailcouk@207.105.83.66...
> Mainy thanks Danny. I'm new to interbase/firebird (actually using the
> latter) and know only basic SQL at the moment. Now I know why I couldn't
> find the correct syntax.
>
> The task records should've been deleted when the server records were
> deleted. This is a one-off and I saw examples of delete using a join in
> other SQL databases.
>
> cheers
> Paul
>
> Van den Wouwer Danny <danny.van.den.wouwer@pandora.be> wrote in
> news:4646d064$1@newsgroups.borland.com:
>
>> Hi Paul,
>>
>> You can't use joins in a delete:
>>
>> I have 2 solutions in mind:
>>
>> 1) DELETE
>>       FROM "Tasks" T
>>      WHERE NOT EXISTS (
>>              SELECT *
>>                FROM "Servers" S
>>               WHERE S."ClientName" = T."ClientName"
>>                 AND S."ServerName" = T."ServerName")
>>
>> --> This isn't the fasted way to go, because the table "Tasks" will be
>> scanned naturally.
>>
>> 2) Write a small stored procedure
>>