On Sun, 20 Nov 2005 12:13:27 +0200, polash26 <polash26@...> wrote:

> What is the equivalent query in FireBird for the following MS SQL query
>
> DELETE FROM T1
> FROM T2 b
> WHERE
> ( SELECT COUNT(*) FROM T1 a WHERE a.ID = b.ID ) > b.Recent
>
> Thanks for any reply.
>
>

What should do that DELETE?

Cheers,
--
Miroslav Penchev