>strSQL = "UPDATE AliasA " & _ "SET AliasAadodc.address = " & YourTextBoxThatContainsAliasBadodc.address.text & _ " FROM Table1 AS AliasAadodc " & _ "INNER Join Table2 AS AliasBadodc " & _ "on AliasAadodc.phone = " & YourTextBoxThatContainsAliasBadodc.phone.text