...but using Streaming Expressions it's possible to achieve the goal, AFAIK https://lucene.apache.org/solr/guide/7_5/stream-decorators.html#innerjoin
Though, probably it won't be so fast as search -- Vadim -----Original Message----- From: Joel Bernstein [mailto:joels...@gmail.com] Sent: Thursday, October 18, 2018 1:03 AM To: solr-user@lucene.apache.org Subject: Re: Trying to retrieve two values from two different collections by sql (V 7.2.1) Joins are not currently supported with Solr SQL. We should create a ticket through a proper exception in this scenario. Joel Bernstein http://joelsolr.blogspot.com/ On Tue, Oct 16, 2018 at 10:56 PM deniz <denizdurmu...@gmail.com> wrote: > found out sth strange regarding this case. If i change one of the values > into > sth else, and the field names are not the same any more, then i can get the > different values > > so the initial query was > > select *collection1.id* as collection1id, collection2.id as collection2id > from > collection1 join collection2 on collection1.name = collection2.name where > collection1.name = 'dummyname'; > > > once i change it into > > select *collection1.age* as collection1id, collection2.id as collection2id > from > collection1 join collection2 on collection1.name = collection2.name where > collection1.name = 'dummyname'; > > I am able to get the age from one collection and id from the second one. > but > if use age for both of the collections, like id field, i am getting only > one > value from one of the collections. > > > > > > > ----- > Zeki ama calismiyor... Calissa yapar... > -- > Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html >