help with access sql query

[E_Gold]

hi

i have 2 tables:

A: serial , Name , Memo

B: serial , Name , Memo

i have another table:

C: serial , Name , NewName , Memo , NewMemo , Status

i need to fill table C in this condition:

1. A:Name = B:Name and A:Memo = B:Memo -> insert to table C and status = 0

2. A:Name <> B:Name or A:Memo<>B:Memo -> insert to table C and fill NewName or NewMemo
and Status = 1

3. if in table B there is new Serial -> insert to table C and Status = 2



how to make this on sql query ? is it possible ?

thanks in advance

 

[RainLover]

I can't see how this can be done with SQL.

You will need to use VBA.

Write what you can and repost for comment.

PS

Name is a Reserved word. Best if you change it to MyName or some thing more fitting.