I am having two tables each having 20 columns. I want to compare these two tables table1 and table2 to get the count of all the records in table1 and all therecord in table2 and the differnece of records in a single query. Is it possible in Teradata 12??
Following query will give you the rows which are different in the two tables: