Many thanks

I will check this solution

Diego

----- Original Message -----
From: "Ali Gökçen" <alig@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, October 20, 2005 7:31 PM
Subject: [firebird-support] Re: Query help: getting non used records in a
table


> damn!
>
> should be:
>
> ...
> num>0
> union all
> select 1,99999 from rdb$database
> where not exists(select 1 from lot where num>0)
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>