I want to use UPDATE command to update in DLWinniners table from TEMP table. The table structure is like this:

DLWinners:  OrgCode C(5) 
            Code    C(5) 
            more fields...

TEMP        Code    C(5) 
            CodeNew C(5) 

If DlWinners.OrgCode is found in TEMP.Code, I want to replace Dlwinners.code with TEMP.CodeNew. I know that this can be done very easily by establishing a relation between two tables. However, is it possible to do this using a single UPDATE command?

Thanks.