Subject count records
Author Jenny Sigvardsdotter
Hi all!
Newbie question again:
Need help with a statement that I�m sure you find very

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

Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes