I am using N-Hibernate and have a class/table called Boxers

I also have a prospect table which tells use if the boxer is a prospect. (this table is one column of just the boxersID)

So i Want to get all boxers that are prospects (meaning all boxers that have there id in the prospects table)

Public static IQueryable<Boxer> IsProspect(this IQueryable<Boxer> query)
{
return query.Where(x => x.Prospect != null);
}

this doesnt trim down my list of boxers to the boxers that are prospect... yet if i debug and look at any boxer it will have True or false next to each one correctly...

Why isnt the where clause correctly trimming down the list?