title: How to use inner join in select with mysql?
body: <p>I want to fetch record from mysql database on following condition</p>
  
  <p>I have the following tables:</p>
  
  <ul>
  <li><p>organization_ Table</p>
  
  <pre><code>organizationId | organizationname
  </code></pre></li>
  <li><p>campaign Table</p>
  
  <pre><code>camp_id | camp_name | adv_id | organizationId
  </code></pre></li>
  <li><p>advertise Table</p>
  
  <pre><code>adv_id | adv_name
  </code></pre></li>
  <li><p>ad_display Table</p>
  
  <pre><code>ad_displayId | adv_id | camp_id |
  </code></pre></li>
  </ul>
  
  <p>Now from ad_display table I want to fetch record like this:</p>
  
  <pre><code>| adv_name | camp_name | organizationname
  </code></pre>
  
  <p>With <code>WHERE</code> Condtion as Where organizationId == ?</p>
  
  <p>So basically I want the advertise list of campaign where organization_id=?</p>
  
  <blockquote>
    <p>Note: there should be multiple entry for same adv_id in camapign table and same camp_id with multiple entry in ad_display</p>
  </blockquote>