从关联表记录数组中查找符合条件的数据, 用给定的字段组合成新表。
如有两集合 users, workouts,数组字段 users.WorkId 与 workouts._id 有关联。
users | _id | Name | WorkId |
1000 | xxx | [2,4,6] | |
1002 | yyy | [1,3,5] |
workouts | _id | Date | Book |
1 | 1/1/2001 | Othello | |
2 | 2/2/2001 | A Midsummer Night's Dream | |
3 | 3/3/2001 | The Old Man and the Sea | |
4 | 4/4/2001 | GULLIVER'S TRAVELS | |
5 | 5/5/2001 | Pickwick Papers | |
6 | 6/6/2001 | The Red and the Black | <