Your query can be seen as an inner join:
select t0.* from employee t0 inner join employee t1 on t0.dept_no =
t1.dept_no where t1.email='a...@email.com'
Maybe JoinUtill can help you.
http://lucene.apache.org/core/7_0_0/join/org/apache/lucene/search/join/JoinUtil.html?is-external=true
On Tue, Apr
Hi guys!
I've a scenario where the lucene query depends on the result of another lucene
query.
For example, find all the employees of the department where one of its
employee's email address = 'a...@email.com'
SQL would be like:
select * from employee where dept_no in(
select dept_no fro
