title: Query to find field duplicate between 9 tables
body: <p>I have 9 tables each with value like </p>
  
  <pre><code>Level_1_tab
  
  Code  Name
  
  ae1   hdgdgd
  ae2   dhdh
  
  
  level_2_tab
  
  code Name
  2     jfjfjf
  3      fkfjfjf
  </code></pre>
  
  <p>similarly <code>level_3_tab , level_4_tab, level_5</code> table so on and so forth till level_9_tab.</p>
  
  <p>I am inserting the code column into a new table and checking for duplicates.</p>
  
  <pre><code>   SELECT
          code, name, COUNT(*)
      FROM
          new_table
      GROUP BY
          code, name
      HAVING 
          COUNT(*) &gt; 1;
  </code></pre>
  
  <p>Can i write a query and compare the code column of these 9 tables and check for duplicates ? that all the rows with duplicate code values should be retrieved</p>