title: mysql joining four tables not using data in one
body: <p>task: List the names of the dentists who had appointments between
  01/11/2016 and 01/12/2016 and administered a procedure named
  ‘Local Anaesthetic.’ </p>
  
  <p>relevant tables:</p>
  
  <p><strong>staff(ID, fname,lname,role)</strong></p>
  
  <p>patient(pID,pFname,pLname,bdate,address)</p>
  
  <p><strong>appointment(aptID, patientID,staffID,aptDate,aptTime)</strong></p>
  
  <p><strong>procedures(procNum,pName,price)</strong></p>
  
  <p><em>aptDetail(aptID,procNo)</em></p>
  
  <p>Issue: I can inner join appointment and staff on ID=staffID but procedure has no common column, is it acceptable to do an inner join on appointment , procedures,staff and aptdetail even though I would not be using anything in aptDetai? Is that the bestw ay to go about it ? Thanks</p>