Jason, I tested it by running the query in navicat and it seems to run just fine. That was before your last post.
The query I ran was :
SELECT Pageurl, Heading, ShortContentLeftPanel, ShortContent, Category, SubCategory FROM pages WHERE Category LIKE '%Adhesion%' AND SubCategory LIKE '%Pull Off Adhesion Tester%';
INNER JOIN productssubcategory ON productssubcategory.url = pages.Pageurl ORDER BY productssubcategory.myorder ASC";
Not sure what to do re your last post. Would you be kind enough to give me an example based on the above so that the inner join comes before the where clause as you suggested???
many thanks Jason