title: SQL query - Self Join referring to common id
body: <p>How would I make an SQL query say displaying the name of (a particular name's) manager.
  Use the following code for an example. I am only using one table.</p>
  
  <pre><code>select lastname
  from staff
  where employeeid = managerid AND last name = 'mclester';
  </code></pre>
  
  <p>The join I know, is where they have ID in common.
  The syntax I used in this example is wrong, but I am trying to find Mclester's manager.
  How would I write this query?
  The logic is eluding me.</p>
  
  <p>Thanks</p>