0

I have 3 collections of 'Demo' cluster:
want to join all columns from these 3 tables.
as
data

{
"email":"jhelliar0@techcrunch.com",
"first_name":"Silvanus",
"last_name":"Spikins",
"mobile":"5279757399",
"car_model":"2500",
"car_color":"Orange",
"company_name":"Fanoodle",
"Desiganation":"Recruiter",
"country":"Georgia",
"city":"Marneuli"
}


Tables are:
emp_login

{
"_id":"$oid":"5e9435ff61a03e23fc7bdb64"},
"id":"1",
"email":"jhelliar0@techcrunch.com",
"password":"diOIE0qd3j"
}

employee

{
"_id":"$oid":"5e940eda61a03e23fc7bd392"},
"email":"jhelliar0@techcrunch.com",
"first_name":"Silvanus",
"last_name":"Spikins",
"mobile":"5279757399",
"car_model":"2500",
"car_color":"Orange"
}

company

{
"_id":"$oid":"5e940eb161a03e23fc7bcfa9"},
"email":"jhelliar0@techcrunch.com",
"company_name":"Fanoodle",
"Desiganation":"Recruiter",
"country":"Georgia",
"city":"Marneuli"
}

use email and password for login from emp_login cluster and after that join all related data from these clusters as shows above in data table

a zEnItH
  • 137
  • 3
  • 11

0 Answers0