: My advice. Forget joins and try to write this in pure
: Solr query language. The more you try to use Solr like
: a database, the more you'll get into trouble. De-normalize
: your data and try again.
with that important caveat in mind, it is worth noting that what you are
essentailly asking about is using multiple filters each containing a
distinct join query...
: > outer_id IN (SELECT inner_id FROM collection1 where zzz = "vvv")
: > and
: > outer_id2 IN (SELECT inner_id2 FROM collection1 where ttt = "xxx")
: > and
: > outer_id3 IN (SELECT inner_id3 FROM collection1 where ppp = "rrr")
?q=*:*
&fq={!join from=inner_id to=outer_id}zzz:vvv
&fq={!join from=inner_id2 to=outer_id2}ttt:xxx
&fq={!join from=inner_id3 to=outer_id3}ppp:rrr
-Hoss
