title: Common records from SQL table
body: <p>I have 3 tables called <strong>CompanyInfo</strong> , <strong>IDInfo</strong> and <strong>PersonalInfo</strong>.</p>
  
  <p>The objective is to fetch <code>P.[First Name], P.[Last Name], I.PAN, C.DOB</code>. </p>
  
  <p>I can put left join or right join to cater this but the sequence of tables may change as it is an input to some tool and user may enter the table names in any sequence like user1 mentions "CompanyInfo, IDInfo, PersonalInfo", user2 mentions "IDInfo, PersonalInfo, CompanyInfo" and so on.</p>
  
  <p>Table data is as below, Is there a way I can fetch the data through single SQL query (may be union). Say for if I want to fetch the data for <strong><em>ID = 4</em></strong>, I should get:</p>
  
  <pre><code>FirstName LastName  PAN        DOB
  User      Four      UAN44444   NULL
  </code></pre>
  
  <p><strong><em>If ID = 3</em></strong></p>
  
  <pre><code>FirstName LastName  PAN        DOB
  User      THree     NULL       1987-12-08
  </code></pre>
  
  <p><strong>CompanyInfo Table</strong></p>
  
  <pre><code>ID  Company    OfficialEmail        EmpID     DOB          Department   Joining Date  Status
  1   RBS        userone@rbs.co.uk    UK222222  1980-11-15   HR           2012-11-20    Inactive
  3   Infosys    userthree@infy.com   IN333333  1987-12-08   Admin        2016-08-18    Inactive
  5   IBM        userfive@us.ibm.com  US55555   1986-03-26   Finance      2014-06-26    Active
  10  Samsung    userten@samsung.com  SK101010  1988-04-04   Admin        2013-04-07    Active
  </code></pre>
  
  <p><strong>IDInfo Table</strong></p>
  
  <pre><code>ID  UAN         TIN         PAN
  2   UAN22222    TIN222222   PAN22222
  4   UAN44444    TIN444444   PAN44444
  5   UAN55555    TIN555555   PAN55555
  </code></pre>
  
  <p><strong>PersonalInfo Table</strong></p>
  
  <pre><code>ID  FirstName   LastName    PhoneNumber      City         Address            ZipCode    Email
  1   User        One         +44-7432564125   London       United Kingdom     RG231FDT   userone@gmail.com
  2   User        Two         +91-987654321    New Delhi    India              110006  usertwo@gmail.com
  3   User        Three       +44-782136425    Guildford    United Kingdom     GUI74DS    userthree@gmail.com
  4   User        Four        +1-230156428     Atlanta      United States      GA 30337   userfour@gmail.com
  5   User        Five        +1-650324152     Houston      United States      TX 77077   userfive@gmail.com
  6   User        Six         +91-8885552223   Mumbai       India              400012  usersix@gmail.com
  7   User        Seven       +91-9998887771   Bangalore    India              560021  userseven@gmail.com
  </code></pre>