Is it possible to update only part of an enterprise geodatabase table?

Question

I have a feature class on an SQL server enterprise geodatabase of Oil and Gas units. It has 75 records with fields like UnitID, name, status, type & admin. 5 of those units(records) are federal and are manually updated. The rest are state units and are tracked/updated thru a different table. How do I update the attributes of the state units only with attributes from the other table without overwriting the federal unit attributes. I've tried joins, and load data but couldn't figure it out.

WesMiller · Answer

Do you have an identifier for those that are state units? You could query those and delete those rows then append the new rows.

Or

if you have a unique id you could join the two tables and use field calculator to move data to the existing records

You may want to set a test environment to play with these options, so you wouldn't mess with your good data