Solr - Join two cores and apply OR condition on each core's field

[ViLi <li...@gmail.com>]

I have two cores and each core has a common field to join the query. I am
able to write Solr query for this.

Each core has a date field in the Solr.Second part of my query is to apply a
date condition on Solr cores by giving OR condition on each core's date
field.

Below is the SQL query that I am using to get the results.

select * from companies core1
inner join company_types core2
on core1.company_type_id = core2.id and
(core1.created_at>=2012-08-1 OR core2.created_at>=2012-08-1)

What would be Solr equivalent to the above SQL query



--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html