I have the following query:

SELECT fd.No,
fd.desc,
nf.nutDesc,
nd.nut_val
FROM fdes fd
inner join nutdata nd on nd.No = fd.No
inner join nutrdef nf on nf.No = nd.No

I get a lot of results can be up to 150. Here is a sample

01001 Butter, salted Protein 0.85
01001 Butter, salted Total fat 81.11
01001 Butter, salted Carbs 0.06
01001 Butter, salted Ash 2.11

How do I construct the query to yield them pivoted like this:

No Desc Protein Total fat Carbs Ash
01001 Butter, salted 0,85 81.11 0.06 2.11

I've looked at the pivot examples I find on the internet, but they make no sense...