how to find identical columns in different tables <p>I have two tables each with multiple columns.</p> <pre><code>+------+-------+--+ | Col1 | Col2 | | +------+-------+--+ | 1 | 1231 | | | 2 | 123 | |table 1 | 3 | 14124 | | +------+-------+--+ +------+-------+--+ | Col3 | Col4 | |table 2 +------+-------+--+ | 1 | 1231 | | | 2 | 323 | | | 3 | 14324 | | +------+-------+--+ </code></pre> <p>I want to check is if <code>col1</code> and <code>col3</code> are identical. That is: all the values match, to be determined using sql?</p> <p>I dont want to use <code>except</code> and also I don't want to take difference of the two columns and check if its zero.</p> <p>Is there a more efficient way to do this?</p>