i have table Controller (ControllerID, ControllerNAme, isActive) and tables SendControllerForCitizenClaim (SendID, ControllerID, Region), table SendControllerForCompanyClaim (SendID, ControllerID, REgion).. and so on .. i have 14 tables of SendController each for a certain purpose. I have a procedure for deleting controllers. I want that if a controller is sent (i.e its id is in at least one of the tables) then isActive=0 otherwise if the controller id isn't present in neither of the 14 tables then delete controler record. How do i do that wihout having to write 14 If Not exists statements?? which method is better and faster in performance? these 14 tables will contain a lot of rows.