Hi Mikhail,
I'm not we can do a negation because Field1 and Field2 are not in the join
condition.
Regards,Nabil.
De : Mikhail Khludnev <m...@apache.org>
À : solr-user <solr-user@lucene.apache.org>; nabil Kouici <koui...@yahoo.fr>
Envoyé le : Jeudi 19 janvier 2017 9h00
Objet : Re: Joining Across Collections
It seems like it can be done by just negating join query or I'm missing
something.
On Wed, Jan 18, 2017 at 11:32 AM, nabil Kouici <koui...@yahoo.fr.invalid>
wrote:
> Hi All,
> I'm using join across collection feature to do an inner join between 2
> collections. It works fine.
> Is it possible to use this feature to compare between fields from
> different collections. For exemple:
> Collection1 Field1Collection2 Field2
> search document from Collection1 where Field1 != Field2
> In sql, this will translated to:
> Select A.* From Collection1 A inner join Collection2 B on A.id=B.idWhere
> A.Field1<>B.Field2
>
> Thank you.
> Regards,NKI.
>
--
Sincerely yours
Mikhail Khludnev
