🚀 go-pugleaf

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
>