two comments

first, sql server problems should really be posted in the sql server forum

ANSI SQL solutions don't always work in every database system

secondly, you've obviously "dumbed down" your situation, beyond the point where it can be solved

the query you posted ~will~ return the results you expect -- bannanas and oranges