Toad World® Forums

Access SQL Issues


#1

I’m using TOAD to execute a update (with join) statement that I have as a macro in Access.

UPDATE q_HOST Q
LEFT JOIN WAVE_REDBACK_MIGRATION_DailyImport W
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?

Thanks!

Mike


#2

Use single quotes for the space instead of double quotes.

UPDATE q_HOST Q
LEFT JOIN WAVE_REDBACK_MIGRATION_DailyImport W
ON Q.ORDER_NUMBER = W.ORDER_NUMBER
SET W.END_USER = Q.HOST_END_USER+’ '+Q.HOST


#3

Thanks!! that worked.