>>>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
- 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.