如何在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)