使用php和oracle在其他表的基础上更新表

I want to update table with unique result after searching the records one by one form other table on the base of House number. Example: I have one table named "Complaint Point" that have two columns "House No" and "Status" Other table named "Complaint Table" that have also two columns "House No" and "Status" but there are multiple entries of same House No. I wanted to compare each house number and status from table "Complaint Table",if any status present "OPEN" then it's update second table "Complaint Point" column status also "OPEN" and if all the status present "CLOSED in table "Complaint Table" then i update the first table "Complaint Point" column status "CLOSED".I want to update table with unique result after