Post
Ask Question

Multiple Join between One or More Table using MySQL

  1. SELECT Table4.company, table1.id, table1.value  
  2. FROM Table1  
  3.     INNER JOIN Table1  
  4.         ON Table2.table1_id = Table1.id  
  5.     INNER JOIN Table3  
  6.         ON Table3.table2_id = Table2.id  
  7.     INNER JOIN Table4  
  8.         ON Table4.table3_id = Table3.id