title: CAML JOINS using SharePoint
body: <p>Assume that there are Emp and Dept tables.</p>
  
  <p>Emp Table has</p>
  
  <pre><code>EmpID
  FirstName
  LastName
  DeptName
  Email
  </code></pre>
  
  <p>Dept table has</p>
  
  <pre><code>DeptID
  DeptName
  </code></pre>
  
  <p>i have to display all the employee details based on DeptName using CAML query.
  Can some one share CAML JOINS example for this scenario.</p>
  
  <p>Thank you</p>