We need help with PHP/mySQL

Hello everyone, I am a first time poster on here so please ask any questions if I have missed anything.

We are a web/graphic design studio based in Oldham near Manchester.

We are building a website with Joomla & Virtuemart for a company with lots of parent/child products. On the parent product page we want to display a table of the child products' custom fields.

I have attached an image to hopefully explain a little better.

There are 5 child products within the example attached with the product sku in the first column and then the custom fields thereafter. There are maybe 40 custom fields but these child products only have values in the columns shown. (wheel width etc)

This would need to be all queried from about 3 different tables in the database (because of the way virtuemart works) and joined together eventually being displayed like the image attached. (highlighted in green)


I think we would be happier for someone to come in to our office but this is not totally necessary.

We need this ASAP really. We look forward to hearing from you.