Mysql from 2 tables

Hi,
I wonder if someone could assist. I am trying to bring the order of presentation from one table and present the information on the page using the order in another table where the common factor in both tables is the url.

I have tried the following (and could be miles off track) and am getting a syntax error

mysql_select_db($database_menuConn, $menuConn);
$query_rsCatsSubsProd = "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";

Any help would be greatly appreciated!!