How can I execute sql such SELECT * FROM <table2> WHERE <field1> IN(SELECT <field2> FROM <table2>)
NoSQLBooster 4.x currently does not support subqueries and SQL JOIN. We plan to provide SQL JOIN and subquery-like functionality in the next major upgrade.
Is it possible to do without SQL?
Yes, you can do it without SQL. MongoDB 3.2+ have supported left-join like aggregation oprerator. The $lookup stage performs a left outer join to an unsharded collection in the same database to filter in documents from the “joined” collection for processing.
More about $lookup, please refer to : https://docs.mongodb.com/manual/reference/operator/aggregation/lookup/
e.g. (NoSQLBooster fluid aggregate API)
Replies have been locked on this page!