>>>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.