Thanks for the link to Tom's page. I'm still working through all that.

What I need is......

Assuming both tables primary keys are identical and same rowcount in tables, for the same primary key match, I need to output if col1 in table1 is different to col1 in table2, OR if col2 in table1 is different to col2 in table2, OR if col3.......etc.

Output would look something like -

For Cust_num 12345, table1.col3 has the value RED, but table2.col3 has the value BLUE