Hi all!
Newbie question again:
Need help with a statement that I�m sure you find very
easy.

I need to count records in 2 tables that have a field
that is '100%' and add the counted records together.
The tables have no relation.

It would work like this:

select count(aktid) from akt
where akt.avtaldebid = '100%' + select count(kliid)
from kli where kli.avtaldebid = '100%'

How would you suggest that I get the correct data.

I use Ib 5.6.

Thanks in advance
Jenny

__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com