I wish to update a table using the SQL Update command. I wish to replace a field in the table with a value located in a temporary cursor:

UPDATE LiveTable SET f02AID = temp.tm_new_aid;
WHERE LiveTable.f02AID in select(temp.f02AID from temp where; temp.tm_chg = "Y")

Table temp contains the old ID (f02AID) and the new ID (tm_new_aid)

This doesn't seem to work as I get a number of changes that result in a new ID of blank.

Anyone have a technique for this?