Thanks Jason, I have navicat.
I have now tried the following and get an error:
SELECT * FROM pages
INNER JOIN productsubcategory ON productsubcategory.CID = prodcat.CID
INNER JOIN pages AS webpages ON webpages.Pageurl = productsubcategory.url
INNER JOIN products ON products.CID = prodcat.CID
WHERE prodcat.Name = 'Adhesion' AND products.Name = 'Pull Off Adhesion Tester'
ORDER BY productsubcategory.myorder ASC
[Err] 1054 - Unknown column 'prodcat.Name' in 'where clause'
I'm lost, can you assist? Many thanks