Moving all prior appointments into one clinic

[wjstarck]

Hello-

I have been using OD since 2008. Back then, I just had a single clinic ("Main") and all the appointments showed on the appointment book. Since then, there was a time that I had 15 different clinics, including the original one, but I have always had Main selected in the appointment book and all the appointments for all the clinics were put on that clinic's appointment so I could see all the appointments without constantly having to switch back and forth.

Now I just am back at one clinic again, but not the original one. All the other clinics but these two are hidden. I want to move all the appointments that were assigned to Main to the other clinic, so I can hide Main. Is there a way I can run a query(ies) to do this?

I hope that's not too confusing.