Thanks for that Jason.
I thought I had included prodcat on:
INNER JOIN products ON products.CID = prodcat.CID
Do I do it like this instead?:
INNER JOIN prodcat ON prodcat.CID = products.CID
I do use navicat but I have to concede that I need some training on it. it's all pretty new to me. So thanks for your patience - appreciated
When I run it, I get this:
SELECT * FROM pages
INNER JOIN productsubcategory ON productsubcategory.PID = products.PID
INNER JOIN pages AS webpages ON pages.Pageurl = productsubcategory.url
INNER JOIN prodcat ON prodcat.CID = products.CID
WHERE prodcat.`Name` = 'Adhesion' AND products.`Name` = 'Pull Off Adhesion Tester'
ORDER BY productsubcategory.myorder ASC
[Err] 1054 - Unknown column 'products.Name' in 'where clause'