title: Inner join more than 2 tables in a single database
body: <p>i want to innerjoin more than 3 tables in one select query in one database all of them are having rm_id as a common column but i want to display the rows of all tables in one sql query is it possible if it is then i would hearly request u to provide some code</p>
  
  <pre><code>select * from 
          bk_det inner join
          bk_rep inner join
          bk_sec inner join
          mut_det inner join
          rm_det inner join
          soil_det 
  on
            bk_det.rm_id =   bk_rep.rm_id =  bk_sec.rm_id =  mut_det.rm_id = rm_det.rm_id = soil_det.rm_id
  </code></pre>