I’m using TOAD to execute a update (with join) statement that I have as a macro in Access.
ON Q.ORDER_NUMBER = W.ORDER_NUMBER
SET W.END_USER = Q.HOST_END_USER+" "+Q.HOST
The error I get is the following:
[ODBC Microsoft Access Driver] Too few parameters. Expected 1
Can I perform updates with joins through the ODBC? Or is there something off about my syntax?