Hi--

Thanks for the reply.

You've got a handle on what I want to return and the industry.

The query I'm still not clear on.  I did clean it up a bit and it ran:

select x.ownername, x.location, x.RVYear, 

( select count(1) from reliefd r 

  where r.plantkey=x.uniquekey ) RV_Mfg_Event_count

from

(

select o.ownername, p.location, p.uniquekey, 

substring( r.datetested from 1 for 4 ) as RVYear

from plants p, reliefd r

join owners o on p.ownerkey = o.uniquekey

where r.plantkey = p.uniquekey and

r.datetested=coalesce(r.datetested, '', null, ' ' )

and RVYear

) x

order by x.ownername, x.location, rvyear

results