It's a little more complex then that, what I need to do is find an organization that has the cxa_on_hold_flag set to 1 and find anyone who has the same cxa_adr_key and set their cxa_on_hold_flag's to 1 as well. The only reason I have a Key in the query right now is to find specific company and check that. Does this make since?

so basically

If organization cxa_on_hold_flag = 1

Then update everyone that has the cxa_adr_key the same as the organization update with cxa_on_hold flag to 1.

Hope this makes since.