如何在mongodb中实现select * from a,b,c where a,a1 =b,b1 and b,b1=c,c1的查询

2024-12-01 17:39:28
推荐回答(1个)
回答1:

update table t1
set (t1.b, t1.c) =
(select t2.b1, t2.c1 from table1 t2 where t1.a = t2.a1)
where exists (select 1 from from table1 t2 where t1.a = t2.a1)