--- In firebird-support@yahoogroups.com, "Miroslav Penchev"
<miroslavp@m...> wrote:

>
> On Sun, 20 Nov 2005 12:13:27 +0200, polash26 <polash26@y...> 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?

Delete will delete data from T1, according to the where condition
(WHERE( SELECT COUNT(*) FROM T1 a WHERE a.ID = b.ID ) > b.Recent ).

>
> Cheers,
> --
> Miroslav Penchev
>