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
