>>>Sure, I hope to get to it later today. I have to add 100,000 records to the two tables to do a true simuation. With my tests so far (using about 30,000 records), the other query was much faster but I won't know a real comparison until I get enough records in the table to test.
>>
>>Great, thanks. Also don't forget to introduce NULLs into the mixture.
>
>For those three fields, nulls are allowed.
Are allowed or are not allowed? If not, then it simplifies the problem - if they are all integers.
If it's not broken, fix it until it is.
My Blog