| Subject | Re: Query help: getting non used records in a table |
|---|---|
| Author | Ali Gökçen |
| Post date | 2005-10-20T17:31:43Z |
damn!
should be:
...
num>0
union all
select 1,99999 from rdb$database
where not exists(select 1 from lot where num>0)
should be:
...
num>0
union all
select 1,99999 from rdb$database
where not exists(select 1 from lot where num>0)