Scenario

The health care provider requires a list of patients and their specilaist doctors. The specialist are doctors to whom the doctor refers for any particular tests or treatment.

Operation

The SQL/XML function XMLQUERY can query on parts of an XML document. It enables XML data to participate in SQL queries.

Solution

A report of the patients and their specialists is generated effeciently.