thanks but i am told not to use a view but to actually update the reasonforreferral column from table a with the description column from table B with an update join statement.