Hi @hadifarnoud
Metabase currently doesn’t support joins on MongoDB through the UI: https://github.com/metabase/metabase/issues/9095 - upvote by clicking on the first post
You would need to do it with a Native question - you’re likely going to find more examples on how to write queries in a forum dedicated to MongoDB or stackoverflow.com
@hadifarnoud So are you getting the same error as in the issue I linked to? Then it’s not supported by the driver.
Metabase will currently not be the right tool for you.