title: What are the steps followed by sql engine to execute the query..??
body: <p>My question is not how to use inner join in sql. I know about how it matches between table a and table b. </p>
  
  <p>I'd like to ask how is the internal working of inner working. What algorithm it involves? What happens internally when joining multiple tables?</p>