You will NOT get the stored fields from the child record with the join operation, it's called "pseudo join" for a good reason.
It's usually a mistake to try to force Solr to performa just like a database. I would seriously consider flattening (denormalizing) the data if at all possible. Best, Erick On Wed, Oct 21, 2015 at 10:36 PM, cai xingliang <caixingli...@gmail.com> wrote: > {!join fromIndex=parent from=id to=parent_id}tag:hoge > > That should work. > On Oct 22, 2015 12:35 PM, "Shuhei Suzuki" <hum2....@gmail.com> wrote: > >> hello, >> What can I do to throw a query such as the following in Solr? >> >> SELECT >> child. *, parent. * >> FROM child >> JOIN parent >> WHERE child.parent_id = parent.id AND parent.tag = 'hoge'` >> >> child and parent is not that parent is more than in a many-to-one >> relationship. >> I try this but can not. >> >> /select/?q={!join from=parent_id to=id fromIndex=parent}id:1+tag:hoge >> >> >> >> >> >> -- >> View this message in context: >> http://lucene.472066.n3.nabble.com/How-to-get-the-join-data-by-multiple-cores-tp4235799.html >> Sent from the Solr - User mailing list archive at Nabble.com. >>