polash26 wrote:

>--- 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 ).
>
>
>
>

A kind of answer that will not help us to help you out

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br