Thanks ChiragNS!

Be well.

Hey,

Excellent point about providing the table definition. Also, the link you suggested I look at is also helpful. I'm not a programming newbie, however, I am a forum-posting newbie because...

Gardin,

Thanks for your suggestion. The query you suggest returns no rows because, in fact, there really are no counts greater than one for the subquery. I think consensus around here...

Hi lemsip,

Thanks for helping. I'm not sure what the results tell you, but here they are.

SELECT T3.Val1

FROMTable3 AS T3

INNERJOIN Table4 AS T4 ON T4.SomeID=T3.SomeID

WHERE T3.Val2 = 1

returns...

ChiragNS,

Yes, you are right in your characterization of the problem. Imported DB in the two MSDE 2000 and SQL 2008 Express. Same query. Two different results (one being an error...

And by the way. I experimented with just rewriting the query so that the subquery is a left join in the outer query and it works just fine every time....

Thanks guys.

Yes, the error in the sql was just my mistake when generalizing the code.

I really do wish I could just change it myself and I'm about ready to just...