>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. :-(
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.