Great question Bill Bell Sent from mobile
> On Jan 18, 2017, at 1: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.