One PART table, a ALL list

PART list the following
The NAME ALIAS CORP DEPT
Zhang SAN zs oracle Beijing unknown
Zhang SAN zs1 oracle Beijing -
Zhang SAN zs2 oracle Shanghai finance department
Li si ls oracle Shanghai
Fifty and ww oracle Shanghai?
.

ALL table of contents below
The NAME ALIAS CORP DEPT
Zhang SAN zs oracle Beijing finance department
Zhang SAN zs1 oracle Beijing research and development department
Zhang SAN zs2 oracle Shanghai finance department
Li si ls oracle Shanghai r&d
Li si ls1 oracle Shanghai hr
Li si ls2 oracle Shanghai logistics department
Fifty and ww oracle Shanghai Marketing Department
Fifty ww1 oracle research and development department of Hong Kong
Fifty ww2 oracle Hong Kong financial department
.

Because some is wrong PART table inside the department, and ALL are on the table inside the department, so want to compare, such as the first threes zs oracle Beijing is unknown, than, should be the finance department, the department how to operate, to ALL the departments in PART list to replace right?