Hey people, looking for some help here.

Basically I have two tables in a MySQL database, `jobs` and `dates`.

Each date references a job by id, sometimes more than one date reference a single job.

I'm doing this query (`x` being a variable integer):

`SELECT * FROM jobs LIMIT x,50`

Now I have a result with 50 job-records and I would like to retrieve all dates pointing to these 50 jobs in one query.

How can this be done without iterating over the result and making a query for each iteration?

Hope I was clear enough :S

PS: Didn't manage to draw a decent table with a little mysql structure.