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.