I have a database with table "A1" of fields
1. Id (Auto number)
2. Server(this matches the name field of A2)
This table has 200 rows in it
and 2nd table A2 of fields
1.name(this matches the server field of A1)
This has 100 rows in it.
I want to accomplish something like this,
Update A1 set A1.ttyport=A2.ttyport,A1.ttyport=A2.ttyport, where A1.Server=A2.name
if A1.Server IS NOT EQUAL A2.name then create another row in A1 with A2.name, A2.ttyport and leaving the rest of the fields with "null"
is it possible? can some one help me with the modification of the query ?