Hi,

Ed's problem is:
I am looking for all of the master records that have one or no detail
records.

With NOT EXIST only master records without detail records selected.
Or I am wrong?

Gabor

Leyne, Sean írta:

>> NOT EXIST is not a good solution for the problem.
>
> Why?
>
> Please elaborate.
>
>
> Sean