>>>>>Instead of using EXISTS I prefer to use LEFT JOIN, which gave you ALL records from 'Main Table' and only these from joined table which match the join condition. When I tested for IS NULL that means that I want only these records from 'Main Table' which didn't have analog in joined table.
>>>>
>>>>Well it don't work either - just gives me same result as my original. :-(
>>>
>>>Can you post some simple data and desired results?
>>
>>Hi BB
>>
>>Thanks. I've emailed you some tables and stuff, and an explanation (took some time to compose :-)
>>
>>Terry
>
>Just received them.

Thanks Boris.

The Group By clause did the trick.

I've sent you an email

Cheers

Terry