title: Multiple table's multiple columns join to same table
body: <p>I have a query. </p>
  
  <p>I have 3 table in mysql database.</p>
  
  <p>I want to connect my tables with these rules, multiple table's, multiple columns join to same table one column.</p>
  
  <p>MySQL example is given below. Thanks in advance.</p>
  
  <pre><code>SELECT
      s.*,e.* 
      , m1.m_id AS 'mid'
      , m1.m_name AS 'mname' 
      , m2.m_id AS 'bid'
      , m2.m_name AS 'bname'
      , e1.e_id AS 'tid'
      , e1.e_name AS 'tname'
      , e2.e_id AS 'topid'
      , e2.e_name AS 'topname'
      FROM s s,e e
      INNER JOIN m m1
      ON s.s_m_id = m1.m_id
      INNER JOIN m m2
      ON s.s_b_id = m2.m_id
      INNER JOIN e e1
      ON s.s_t_id = e1.e_id
      INNER JOIN e e2
      ON s.s_t_t_id = e2.e_id
      WHERE s_id =1
  </code></pre>