Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. db.member.aggregate([
  2. {$lookup:{
  3. from: 'cards',
  4. localField: '_id', // 這裡是指定 member 的會員編號
  5. foreignField: 'user_id', // 這裡是指定 card 的會員編號
  6. as: 'cards'
  7. }},
  8. {$match:{
  9. 'cards': []
  10. }},
  11. {$project:{
  12. name: 1,
  13. phone: 1
  14. }}
  15. ]);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement