>Do you have more than 1 record in the CompassQuery that has CompaignID = 140?
>Yes, there are 68 records. Some of the WHERE clauses are quite long.
>
>Why you're not using what I posted - it should have lead to the correct query.
>I split it up because the string was too long and I wanted to see if it would help.

Ok, try with the fix from the previous message (just one where condition).

For multiple where conditions one possibility is to introduce them all with OR and (), another, which I posted originally, is to do UNION ALL query.