It's called "pseudo join" for a reason. It's not built to do what you want. There's no way to combine fields in the "from" and "to" clauses in the output. The "from" clause can be thought of as a filter.
The first choice is usually to denormalize the data if possible. Best, Erick On Sun, Jan 12, 2014 at 9:55 PM, solr2020 <psgoms...@gmail.com> wrote: > Hi All, > > Can anyone please explain how solr join query works in solr4.2. > we have 2 different documents.Both are in the same index. > > document1 contains the columns: > > docdate: 01-12-2012 > previousmonthdate :01-11-2012 > price:15 > and some more fields. > > document2 contains: > > docdate :01-11-2012 > previousmonthdate :01-10-2012 > price:10 > and some more fields. > > Here we have the same value in previousmonthdate (in document1) and docdate > (in document2).So we want to make a join query based on this to retrieve > these in a single document. > > the final document should look like this. > docdate: 01-12-2012 > previousmonthdate :01-11-2012 > price:15 > price:10(this is from document2) > > Is is possible using Solr join query??? Or do we have any other approach?. > > Please help.. > > Thanks. > > > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/How-Solr-join-query-works-tp4110982.html > Sent from the Solr - User mailing list archive at Nabble.com.