Hi There,

I am trying to run the query below in the Pervasive SQL V8.6 Data Manager.

UPDATE "TEST1" INNER JOIN "TEST2" ON "TEST1"."PARTNUM" = "TEST2"."PARTNUM" SET "TEST1"."DESCRIPTION" = "TEST2"."DESCRIPTION"

I get the following error:

"ODBC Error: SQLSTATE = S1000, Native error code = -1603
Currency not on a record."

Both tables have PARTNUM set as a primary key with no duplicates allowed.

The user manual says to add a group by or order by to solve the problem, but I don't know how to add one in an update query. Can you help?