title: SQL Sub-query -- Select JobID with a maximum JobValue
body: <p>This seems like an easy thing, but I'm drawing a blank. </p>
  
  <pre><code>Select * from 
  ....
  inner join 
    (
     select JobsID, Value from Jobs where Value **is the highest**
    ) as MaxJob on MaxJob.CustID = A.CustID
  
  inner join
    (
     select other information based upon MaxJob.JobID
    ) as OtherStuff
  </code></pre>
  
  <p>Is there a nice way to have that first subquery give me the Job ID of the job with the maximum Value?</p>
  
  <p>Thanks... this seems easy and I'm sure I'm overlooking something very elementary. One of those days...</p>
  
  <p>Edit: Due to this question being a bit ambiguous, I've written up a much more detailed question <a href="https://stackoverflow.com/questions/1258469/sql-server-2005-syntax-help-select-info-based-upon-max-value-of-sub-query">here</a> (since this question was answered correctly). </p>