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
