SQL - select multiple records which only exist in multiple tables <p>I have some 20+ tables consisting of 20,000+ records each, I wish to query for only record values which exist in all tables. I'm not sure if there was a different approach than group all together with UNION? </p> <p>Example:</p> <pre><code>Table_A: 1,2,6,9,12,15 Table_B: 2,6,11,15,18,26 Table_C: 6,12,14,15,23,24 Table_D: 3,4,5,6,8,15 </code></pre> <p>Result: Only 6 &amp; 15 would return!</p> <p>Required Result:</p> <p>Only values which appear in all tables (to be inserted into new table!)</p> <p>Many thanks!</p>