Rick DeBay wrote:

> Thanks. I'll use DISTINCT or FIRST 1 depending on my mood at the time.

First is cheaper - the system retrieves only one record. Distinct has
the advantage of letting you know if you've made a bad assumption about
your data. Any aggregate function will also work and might be more
reasonable than arbitrarily accepting the first value.

Regards,


Ann