thanks for your help so do you think I should execute solr queries twice ? or is there any other workarounds
On Mon, Nov 30, 2009 at 3:07 PM, Shalin Shekhar Mangar < shalinman...@gmail.com> wrote: > On Mon, Nov 30, 2009 at 2:26 PM, Mark N <nipen.m...@gmail.com> wrote: > > > field2="xyz" we dont know until we run query1 > > > > > Ah, ok. I thought xyz was a literal that you wanted to search. > > > > 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 > > > > > No, there are no joins in Solr. Consider de-normalizing your schema, if you > haven't. > > -- > Regards, > Shalin Shekhar Mangar. > -- Nipen Mark