Hello,

I'm trying to update the value in tableA, therefore I need to use the insert and update command, I tried to modify my code using your syntax but it still doesn't work. In this case table A is identification table and table B is AOP5. The error message states the substring is not recognized.

Dim mySQL_Statement As String = "UPDATE IDENTIFICATION_DATA " & vbNewLine & _
" INNER JOIN " & vbNewLine & _
" aop5 " & vbNewLine & _
" ON IDENTIFICATION_DATA.NIIN " & _
" = substring(aop5.NSN,5,11) " & vbNewLine & _
" SET IDENTIFICATION_DATA.NARC = " & _
" aop5.sn "