title: How to JOIN three tables in Codeigniter
body: <p>I'm using codeigniter framework to develop one music cms. i have 3 tables in mysql database, Currently im working in "Album" Table and "Model, Controller". i want to SELECT "Album" Table 1 and JOIN "Album" -> "cat_id" with "Category" -> "cat_id", and fetch all categories records.</p>
  
  <p>Then i want to JOIN "Album" -> "album_id" on  "Soundtrack" -> "album_id" then fetch all soundtrack records A to Z.</p>
  
  <p>Please somebody help me to show proper codeigniter query, how i can SELECT  and JOIN Tables then fetch records from 3 tables, ?</p>
  
  <p><strong>Table 1 -> Category</strong></p>
  
  <ul>
  <li><p>cat_id</p></li>
  <li><p>cat_name</p></li>
  <li>cat_title</li>
  <li><p>date</p>
  
  <p><strong>Table 2 -> Album</strong></p></li>
  <li>cat_id</li>
  <li><p>album_id</p></li>
  <li><p>album_title</p></li>
  <li><p>album_details</p>
  
  <p><strong>Table 3 -> Soundtrack</strong></p></li>
  <li><p>album_id</p></li>
  <li><p>track_title</p></li>
  <li>track_url</li>
  <li>date</li>
  </ul>