Hi,
Thanks for your help. However, Access does not accept this either, I get an error saying (the same one as previously) join not supported. I got it working by using:
SELECT customer.customer_id, cust_category.cust_category_name
FROM
(
(customer) LEFT JOIN categories_of_customers ON...