Can Solr query join on multiple fields? Or, anyway to achieve equivalent
function with current join syntax?
From the Solr Wiki and examples found on the web, the syntax only supports join
on one field from a doc to another field of other docs, like below:
{!join from=customer_name to=name}state:TX
We have two type of docs and want logically join on more than one field, and we
want to retrieve one type of doc with filters on the other type of docs; the
equivalent SQL query will be like
select * from order where exists (select 1 from customer where customer.name =
order.customer_name and customer.address=order.ship_from_address and
customer.state='TX')
Can the Solr query achieve this type of join? Or, any technical reason not
support join on multiple fields?
Thanks,
Haiying
