Matching Value from an SQL db to XML

[mehdibb]

I'm pretty new to programming so bear with me.I have an XML File like as follows:\[code\]<item> <SKU>123</SKU> <price>$12.99</price><item><item> <SKU>456</SKU> <price>$14.99</price><item>\[/code\]And I have a SQL table of values like as follows:\[code\]+----+----------+| SKU | Price |+----+----------+| 123 | $9.99 || 456 |$10.00 || 789 | $1.00 |+----+----------+\[/code\]I want to look up each SKU from the SQL database and see if that SKU exists in the XML file. I also want to match the SKUs in the SQL table to the SKUs in the XML file and write out the price of each (so for Example: SKU 456, $14.99, $10.00).I have no idea where to even begin. Some questions:1) I think I could figure out a way to do things if I copied the XML values into another SQL database doing a simple inner join. Is there a way to do this without copying the xml values to a database? A general direction of what I should be researching would be fantastic!Thanks in advance.