Thank you very much. That is now working
Out of interest, can anyone tell me, would I be able to modify the query to this, or is that a big job?
SELECT Product_Category.product_code, Product_Category.product_name
FROM Product_Category, Product
WHERE
Product_Category.product_code = Product.product_code
and category_code = 'TA'
Out of interest, can anyone tell me, would I be able to modify the query to this, or is that a big job?
SELECT Product_Category.product_code, Product_Category.product_name
FROM Product_Category, Product
WHERE
Product_Category.product_code = Product.product_code
and category_code = 'TA'