SQL, orders with product name and attribute.

Hello all, wonder if you can help please as i think my head is going to explode!

I'm trying to write some sql to display orders along with the products in the order, along with their description and then the attributes selected.

I'm  going around in circles with doing the join in the sql and the rest on the sql.  

Any help appreciated :)

Thank you.

This may help you
https://www.nopcommerce.com/boards/t/40599/sql-query.aspx

But, notice that customer selected attributes are stored as XML

Thank you MVP for the link, very helpful. Now trying to get the join working to from the lines in the order back to the product table. I got the attribute infomation in the SKU, so hopefully I just need to pull that value back.

SQL used to be easy when I used it regularly, but these days finding it hard :)