title: Linking table in same SQL Server database to find or match data easier
body: <p>I will be having multiple tables depends on how many type of data I will be receive after reading a file.</p>
  
  <p>So far I have done creating and insert all the data accordingly into multiple tables where they should belong to. </p>
  
  <p>How to link those table together in a same database so that I can find the repeated data in different tables. </p>
  
  <p>I need to match all the multiple tables together so that I can find or match all the data together to see how many times they have appear in different tables and allocate where are them. Is there anyway to do so? My previews coding is done in Python Pyodbc module, about this linking table, it can be done in a SQL Server query right?</p>
  
  <p>When I want to know how many times the 4 has appear in the column No_Person_in_the_room in both tables or more tables, it will shows the number of 4 has appear how many times in all the tables</p>
  
  <p><a href="https://i.stack.imgur.com/pk5fq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pk5fq.png" alt="enter image description here"></a></p>
  
  <p>And also</p>
  
  <p><a href="https://i.stack.imgur.com/Mo1tx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Mo1tx.png" alt="enter image description here"></a></p>