I think a few people have touched on it, but it is pretty important.If you are pulling out a very small amount of records, say, just one or two, then using Except would probably be the better way to go, if you can filter to this level in the except part of your clause.If you are, however, pulling out a rather large set of data, the left outer joins will be the better choice.At least, he is what I