SELECT `catalog_module-product_categories.product_id` AS id,
`catalog_module-products.name` AS name,
`catalog_module-products.product_code` AS code 
FROM `catalog_module-product_categories,catalog_module-products` 
WHERE category_id = 2 
AND `catalog_module-product_categories.product_id` = `catalog_module-products.id`