MongoDB等于SQL,带有子句?
我想用SQL的子句查询某些内容,查询:
with t1 as(
select field1, field2, calculatedField
from table1
),
t2 as (
select field1, field2, calculatedField
from table 2
)
select a.*, b.*
from t1 as a
left join t2 as b on a.field1 = b.field1
如何在MongoDB中实现这一目标?我找不到的MongoDB中的操作员
I want to query something with SQL's WITH clause, query:
with t1 as(
select field1, field2, calculatedField
from table1
),
t2 as (
select field1, field2, calculatedField
from table 2
)
select a.*, b.*
from t1 as a
left join t2 as b on a.field1 = b.field1
how can I achieve this in mongodb? i can't find an operator in mongodb for WITH
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论