Subject Re: Query help: getting non used records in a table
Author Ali Gökçen
Sorry it was prev. test copy
do change the last lines with this:
union alll
select 1,99999 from rdb$database
where not exists(select 1 from lot where num>0)

Let me know, if you need explain about my sql command.