I am working on spring mongodb. I want to apply join between two tables/collections based on two fields or columns of tables/collections. I have already done joining collections based on one field, using lookup. But it seems that lookup don't allow joining on two fields. I also tried to use match with lookup, but match compare field with given string and don't allow to match one field with other field of collection in spring mongodb (or may be i am doing wrong).
How can i join two collections based on two fields in spring mmongodb?