Remove identical fields in 2 tables

[hugmarcel]

Hi

having to tables X and Y having identical fields CUSTOMER.NAME and CUSTOMER.ADDRESS.

1.) How can I detect the identical fields and remove them from both tables?

2.) How can I detect non-identical fields and remove them from both tables?

Without using the CONCAT() function.

Thx a lot - Marcel

[MK_QSL]

Can you post an example please?