title: SQL query using (self?) Join
body: <p>I have a problem with a question I don't fully understand. Was wondering if anyone could help me with it, Or at least help me understand.</p>
  
  <p>Lets say we have a table 'Jobs' with 2 columns job numbers 'jobnum', and employee numbers 'empnum'</p>
  
  <pre><code>Table: Jobs
  ---------------------------------------
  |      jobnum      |      empnum      |
  ---------------------------------------
  |       125        |       4785       |
  |       100        |       4200       |
  |       305        |       4001       |
  |       125        |       4224       |
  |       102        |       4840       |
  |       100        |       4224       |
  |       107        |       4534       |
  |       255        |       4200       |
  |       208        |       4224       |
  |       301        |       4785       |
  ---------------------------------------
  </code></pre>
  
  <p>I like the job that was done at a certain work site, lets take jobnum '125', and want to know the other jobnums of the same employees. It shows that two people worked on jobnum 125. '4224' and '4785'. How would I write a SQL query that would output the jobnums of the same people that did job '125'. I am supposed to use Join query <strong>and cannot use sub-query</strong></p>
  
  <p>I understand how I would do it using a sub-query but don't know how I would going about it using a Join. I am assuming I would do a self join? Perhaps I don't fully understand Joins =/</p>