Lucene isn't a relation database. However there are some methods to
have a relational like search:
1) Index time joins:
http://blog.mikemccandless.com/2012/01/searching-relational-content-with.html
2) Query time joins:
http://www.searchworkings.org/blog/-/blogs/query-time-joining-in-lucene
Martijn
Trupti,
Looking over your sample query, that looks like you're trying to do a SQL
query against a database instead of a Lucene query. If you're going against
a SQL database, Lucene isn't a good tool for the problem you've outlined.
If you're using SQL, you can do multiple joins to link multiple ta