>Thanks Sergey. However, I need also to include the rest of the fields from each table, which differ from each other.

Are you saying that fields you listed are the key fields? If they match in tableA and tableB wich record do you wont to include in the result, from tableA or tableB?