compare date with each other and...

Hello, I have a question. I have her two tables ( X and Y). In the X are following fields (Nr,Name,Transaction,account). The Y- table has the following fields (Nr, code, description…). I have to search in the second table for equal numbers.When I have found one I have to give aacount in the first table code XXX, when I have found an equal number I have to give account code YYY. I hope I was clear enough ??

Hi, No, you are absolutely not clear. Thanks Suresh.