I would truly appreciate help on the following matter:
I have two Datasets (each a result of a different database select):
1. Jobs: int jobid (primary key), string jobname, string jobtype.
2. UserJobs: userid, jobid (N-To-N relation).
I would like to create a dataset that will contain all the jobs of a certain user. For example, I want have a dataset with all the jobs of a user with userid=5.
How can I do that efficiently? (I have got about 100,000 records in the UserJobs table - for about 1000 users).