Hello sql expert,
I am trying to query these two fields from Product table to XML output but I having an issue, what I am trying to produce is an xml like below:
<Products_Inventory> <Inventory> <Product Color="Black">1025</Product> <Product Color="White">1123</Product> <Model/> </Inventory> </Products_Inventory>
From my sql table:
SELECT Product_A ,Product_B ,Model FROM Product
The value of table Product is:
How do I update my above query to get the XML output I am trying to achieve above?
Thank you all