Thank You. Work's fine. Appretiate your help

Thank You for providing a very good sql script. My production table has lot of medical records in the treatment tables. Each medical record has one department and...

Thank You for replying. It is the same person. Sorry for the confusion.

Please note the department and facility are not the column names. They are referenced in...