title: Get data from multiple tables in MySQL
body: <p>Table 1 :- tbl_contacts</p>
  
  <p>Fields</p>
  
  <pre><code>user_id
  
  contact_id
  
  first_name
  
  last_name
  </code></pre>
  
  <p>Table 2 :- tbl_phone_details</p>
  
  <p>Fields</p>
  
  <pre><code>contact_id
  
  phone_number
  
  phone_type
  </code></pre>
  
  <p>Table 3 :- tbl_email_details</p>
  
  <p>Fields</p>
  
  <pre><code>contact_id
  
  email_address
  
  email_type
  </code></pre>
  
  <p>QUERY - </p>
  
  <pre><code>SELECT 
         tbl_contacts.*, tbl_email_details.*, tbl_phone_details.* 
  FROM 
         tbl_contacts, tbl_email_details, 
         tbl_phone_details 
  WHERE 
         tbl_contacts.user_id = '1'
  </code></pre>
  
  <p>I want to get first_name, last_name, Phone and Email details of particular user_id. I have used above query but its giving me repeated results and I am having less knowledge on DB queries like JOIN and INNER QUERY.</p>
  
  <p>If anyone has any idea, please kindly help.</p>
  
  <p>OUTPUT NEEDED:-</p>
  
  <p>contact_id, first_name, last_name, phone_number, phone_type, email_address, email_type 
     (Here email and phone number can have 1 or more values for particular users).</p>