Query issue

[mashtha9]

Hi all,



I have two tables:
Table A, fields a1 (text), a2 (date)
Table B, fields b1 (text), b2 (date)

a1 and b1 are linked as 1-n
a1 is PK of A

I am using the following query:
UPDATE A
SET A.[a2] = B.[b2]
WHERE (A.[a1] = B.[b1]) AND (B.[b2] > A.[a2]);

When i run the query, i get the pop up where I am asked to enter a2 and b2 instead of automatic updating. Why is my query not working? Any help would be really appreciated.

[mashtha9]

never mind. found the solution myself. using inner join and set solves the problem