table1.costctr needs to be converted to a new value. If have put the pseudo code below but would like to do it in an SQL statement.

if table1.costctr = costctr.o_costctr and
control.site_id = costctr.site_id
replace table1.costctr with costctr.n_costctr
endif

table1 has about 1000 records, and a couple hundred fiels
costctr has about 8000 records and only a couple of fields
control has only 1 record and only a couple of fields


thanks

Brenda