c# - Microsoft Access Join - Multivalued data -

i new access , working on project has database containing 3 tables : 1 personal data of employees, second education details, , 3rd occupation. 3 have common emp_id common connector. made left join between first 2 tables associate education degrees respective employees. since many employees hold more 1 degree, have multiple entries same employee following:

emp_id name age gender degree university

1. john doe 32 m abc university

2. john doe 32 m ms xyz university

3. jane miller29 f pwq university

4. person3 45 f btech mnb university

the first table consists of first 4 rows of above query result , second table has last 2 rows emp_id of result.

i wanted know if there way in combine these multiple values , make them 1 single record, because if have join occupation table (which contains multiple records each emp_id), end having lot more 1 record per person. have take data , use in c# program. have idea of how go this? or there better solution can follow! lot in advance!