The most intuitive way to write a comparison of two tables and spit out the # of rows that are the same involves a left join: select ‘Investment’ as TableName, count(*) as RowCount from Investment_A a, Investment_B b where a.col1 = b.col1 AND a.col2 = b.col2 AND a.col3 = b.col3 AND a.col4 = b.col4 This [...]
