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