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 >
