Hi,
i created two temp tables in sql having same number of columns and same column name both temp table have same values
Table 1
Distributor_Key Date_of_Data Physical_Cases Item_Key
AthensTN 2018-02-01 6.5 MQACU13CS
AthensTN 2018-02-01 0.33 MQACU13RW
AthensTN 2018-02-01 1 MQACU14CS
AthensTN 2018-02-01 1 MQACU14CS
table 2
Distributor_Key Date_of_Data Physical_Cases Item_Key
AthensTN 2018-02-01 6.5 MQACU13CS
AthensTN 2018-02-01 0.33 MQACU13RW
AthensTN 2018-02-01 2 MQACU14CS
in table 2 1 record is missing and one column value in not same i need to find those difference how to do that