title: How to get data from 3 diffrent tables in MySql
body: <p>I have a situation from which i have to get the data from three different tables and i want to use single query for that .How can we do this .Please help me .</p>
  
  <p>Here in the situation:</p>
  
  <pre><code> table_one
  
  emp_id   dept_id      name
  GT102    206          Test
  GT103    201          Test1
  GT105    111          Test2
  GT106    340          Test3
  
  table_two
  
  Dept_id      department
  
  111          Finance
  340          Product
  201          IT
  
  table_three
  
  emp_id      Salary
  
  GT102       10,000
  GT103       20,000
  GT105       40,000
  GT106       50,000
  </code></pre>
  
  <p>I want to fetch department and salary of Test2.Please help me </p>