Don't write this query in lucene Step back and
take a deep breath and take off your database hat.
Lucene is NOT a RDBMS, it is a text search engine. You'll
drive yourself crazy trying to make Lucene into one. AND
you'll be very dissatisfied with the results.
Instead, think of how you can ind
Hi, i am newbie for lucene search. i have a bit complex query like this:
SELECT mat.name matName,
FROM LIB_MATERIAL mat,
LIB_MAT_TYPE matType ,
LIB_SHELF shelf ,
LIB_ROOM room ,
FZA_PERSON res
WHERE mat.shelf_id = shelf.record_id(+)"
AND shelf.room_id = room.record_id(+)"
AND mat.material_typ
