selecting multiple items form multiple tables with min and max : <p>I'm having a little trouble figuring out this SQL statement. I have three tables <code>employee</code>, <code>job</code>, and <code>job type</code>.</p>

<p><code>job type</code> is reference table. It has the name of the job, how long that job takes, and how much is charged for that job.</p>

<p><code>job</code> has records of what job was performed for what client by which employee and the date performed. It links to <code>job type</code> <code>jobname</code>.</p>

<p><code>employee</code> has name of employee, and <code>employee id</code>. It links to <code>job</code> table by <code>employee id</code>.</p>

<p>I need to display a list of all employees as well as the cheapest and most expensive jobs they did for a given year.</p>

<p>I think I will probably have to have an embedded select and a few <code>joins</code>. Maybe a <code>union</code>The complexity is just too far out of my experience. I'm not even sure where to being to be honest.</p>
