Hi Don, On Wed, Jul 29, 2009 at 1:42 PM, Donal Murtagh<domur...@yahoo.co.uk> wrote: > Course.name Attendance.mandatory Student.name > ------------------------------------------------- > cooking N Bob > art Y Bob > > If I execute the query "+courseName:cooking AND +mandatory:Y" > it returns Bob, because Bob is attending the cooking course, and Bob is > also attending a mandatory course.
What you're describing is "+courseName:cooking OR +mandatory:Y". What you want is what you've written above, "+courseName:cooking AND +mandatory:Y". I'm not sure why you have a result for this AND query, when it does not match any of the documents listed. Can you send the code for the query parsing / generation you're using? Thanks, Phil --------------------------------------------------------------------- To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org For additional commands, e-mail: java-user-h...@lucene.apache.org