Teradata Procedure to compare two tables

[i150371485]

Hello Experts,

I am newbie to teradata. I have a requirement to compare the two tables in teradata. I have used minus query to find out te differences. i used to do A MINUS B UNION B MINUS A . But it if there are any differences it will dispaly whole reocrds. Is there a way we can get mismatches report as below

KEYFIELD is PRIMARY KEY in both Souce and target tables.

Thanks in advance.

Cheers.

 

[larry609]

Just do 2 selects into a temp table that first show fields from B not in A, then fields from A not in B.