title: Please explain middle join in SQL
body: <p>I recently was asked for a question on sql about <strong>middle join</strong>? </p>
  
  <p>I did got the job..however, could someone explain about middle join in sql for example with syntax and where it is used?</p>
  
  <p>Thanks</p>