enter image description here

By joining first four tables .. how we can generate a fifth table in the image using mysql ?

select m.meetings_id,client_name,group_concat(concat(cc.contact_name)),summary from
meetings m 
   left Join client c on c.client_id = m.client_id  
   left join client_contact cc on cc.client_id= c.client_id
   left join meeting_attendees ma on cc.contact_id = ma.contact_id  
   group by m.meetings_id
   order by m.meetings_id

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.