title: Retrieve data from Multiple table From Ms access
body: <p>I make two table one is <strong>exp_detail</strong> and 2nd is <strong>exp_head</strong>.</p>
  
  <ul>
  <li><p><strong>exp_detail</strong> Table contain exp_id,Amount_paid,sr_no and exp_Description <strong>column</strong></p></li>
  <li><p><strong>exp_head</strong> table contain exp_id and exp_Name <strong>column</strong></p></li>
  </ul>
  
  <p>Now I am using this query to retrieve data from <strong>exp_detail</strong> table. This will display correctly. This query is </p>
  
  <pre><code>select sr_no, e_date, e_paid, e_des 
  from exp_detail 
  where e_date = #" + this.dp_expDetail.Value.Date + 
  "# order by exp_detail.sr_no"
  </code></pre>
  
  <p>But problem is this I retrieve <code>exp_Name</code> using the primary key and foreign key from <code>exp_head</code> table in this above given query. How it is possible?</p>