Solr Join is _not_ sql subquery and won't work like one. There's a reason it's called "pseudo join" in the JIRA issues.
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. Best Erick On Wed, May 29, 2013 at 10:34 PM, cmd.ares <cmd.a...@gmail.com> wrote: > http://wiki.apache.org/solr/Join > I found solr join is actually sql subquery,does solr support 3 tables jion > ? the sql like this > SELECT xxx, yyy > FROM collection1 > WHERE > 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") > > how to write the solr request url? > thanks. > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/multiple-field-join-tp4066930.html > Sent from the Solr - User mailing list archive at Nabble.com.
