| Subject | Re: Query help: getting non used records in a table |
|---|---|
| Author | Ali Gökçen |
| Post date | 2005-10-20T17:07:56Z |
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.
Ali
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.
Ali