when using a join query, you dont list all the tables in the from statement:
prodcat, products, productsubcategory
you only list the main table:
and include the other tables using the join statements:
INNER JOIN prodcat ON......
INNER JOIN products.....
INNER JOIN productsubcategory.....
I think you would be better using a tool like navicat that includes a visual query designer in it to create your recordset queries.