Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
how to get multiple records against one record based on relation
how to get multiple records against one record based on relation ¬†using -'mysql,sql,database'
I have two tables Organisation and Employee having one to many relation i.e one organisation can have multiple employees. Now I want to select all information of a particular organisation plus first name of all employees for this organisation. What‚Äôs the best way to do it? Can I get all of this in single record set or I will have to get multiple rows based on no. of employees? Here is a bit graphical demonstration of what I want:
Org_ID ¬†¬†¬†¬†¬†Org_Address ¬†¬†¬†Org_OtherDetails ¬†¬†¬†Employess
1 ¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†132A B Road ¬†¬†¬†List of details ¬†¬†¬†¬†Emp1, Emp2, Emp3.....
Sep 22, 2015
to add a comment.
Related Hot Questions
Government Jobs Opening