Update Status?

table1 has 3 fields:
bookNumber
123
234
345

status -- status defaul value is 0

partnerNumber
1
2
3


table 2 has 2 fields
bookNumber
234
345
567
789
partnerNumber
1
2
3
4

A stored procedure named remove_books, which remove books if the conditions are true.

If stored procedure is executed. That means, it removes the bookNumbers from table2 if the conditions are true. Lets say it removes 234 from table2


then
do update in table1 status = 1 for BookNumber 234.