field2="xyz" we dont know until we run query1 To simply i was actually trying to do some kind of JOIN similar to following SQL query
select * from table1 where *field2* in ( select *field2 *from dbo.concept_db where field1='ABC' ) if this is not possible then i will have to search inner query ( select *field2 *from dbo.concept_db where field1='ABC' ) first and then only run the outer query thanks chandan On Mon, Nov 30, 2009 at 2:25 PM, Shalin Shekhar Mangar < shalinman...@gmail.com> wrote: > On Mon, Nov 30, 2009 at 2:02 PM, Mark N <nipen.m...@gmail.com> wrote: > > > hi shalin > > > > I am trying to achieve something like JOIN. Previously am doing this with > > two queries on solr > > > > solr index = ( field1 ,field 2, field3) > > > > query1 = ( for example field1="ABC" ) > > > > suppose query1 returns results set1= { 1, 2 ,3 ,4 } which matches query1 > > > > query2 = ( get all records having field2="xyz" for each records i.e > for > > set1= {1,2,3,4} returned by query1 ) > > > > > That sequence of queries will return documents which have field1="ABC" and > field2="xyz". The same result can be obtained in one query with > q=+field1:"ABC" +field2:"xyz" > > Have I misunderstood the problem? > > > > Am not sure if I could do something like this using the nested solr query > > from link > > > > http://www.lucidimagination.com/blog/2009/03/31/nested-queries-in-solr/ > > > > > No, nested queries can only influence scores. They do not filter the > results. > > -- > Regards, > Shalin Shekhar Mangar. >