db.BORROWEDBOOKS.aggregate([
{
$lookup:{
from:"MEMBER",
localField:"memberID",
foreignField:"memberID",
as:"member"
}
},
{
$lookup:{
from:"BOOK",
localField:"ISBN",
foreignField:"ISBN",
as:"book"
}
},
{
$unwind:"$member"
},
{
$unwind:"$book"
},
{
$project:{
_id:0,
memberID:"$member.memberID",
firstName:"$member.firstName",
lastName:"$member.lastName",
title:"$book.title",
dateBorrowed:1,
dueDate:1,
returnDate:1,
fineAmount:1
}
}
])