db.schools.insert({schoolNumber: 218, schoolName: "School A"});
db.schools.insert({schoolNumber: 444, schoolName: "School B"});
db.schools.insert({schoolNumber: 123, schoolName: "School C"});
db.pupils.insert({pupilName: "Maxim", pupilSchool: 218});
db.pupils.insert({pupilName: "George", pupilSchool: 218});
db.pupils.insert({pupilName: "Nina", pupilSchool: 444});
db.pupils.insert({pupilName: "Alice", pupilSchool: 444});
db.pupils.insert({pupilName: "Ann", pupilSchool: 123});
cursor = db.pupils.find().sort({pupilSchool: 1}); null;
while(cursor.hasNext()) {
pupilObj = cursor.next();
numberOfSchool = pupilObj['pupilSchool'];
schoolObj = db.schools.findOne({schoolNumber: parseInt(numberOfSchool)});
nameOfSchool = schoolObj['schoolName'];
nameOfPupil = pupilObj['pupilName'];
s = nameOfPupil + " : " + schoolObj['schoolNumber'] + " : " + nameOfSchool;
print(s);
}
Ann : 123 : School C
Maxim : 218 : School A
George : 218 : School A
Nina : 444 : School B
Alice : 444 : School B