Searching for multiple criteria (accross 2 tables)

2008-02-15 Thread lmctndi
Hi all, [ Sorry for the cryptic title but I can't think of a better one] I am trying to integrate Lucene as a search engine for my database and would appreciate some help on a problem. First, some info about the development platform, I am developing on Windows using Hibernate for DB transaction

Re: Searching for multiple criteria (accross 2 tables)

2008-02-15 Thread lmctndi
Thanks for your reply. Your idea prompts more questions: I understand what you are saying but don't know how to implement it. How do you go about joining all rows of all the tables belonging to one person and to index them so that I can actually use "+Fname:john +County:USA" as a query? Eric