C sharp dataset of two tables

Question

Hi guys,

This is the problem.

I have three tables: factory, employee, activity
In my db I use an intersectiontable factoryemployeeactitvity.

Now I want all employees of a certain factory.

I call a dataset from that intersectiontable to get all the id's of the employees who are related to the factory. So far so good.

But now I want to get the employeedetails for every record in that dataset.

Can someone please help me because I'm losing it :-)