Hey experts!



I have a table "Orders" that has a colum "Product" which contains either a product name or then entry "All", standing for all products.

I have another table that is called "Products" and it contains all products. I would like to create a query that replaces the "All" entries with all the product names. All other information should remain the same.

The screenshot I took (see attachment) probably tells the story better.

This simple think has taken me 6 hours so far . Any input would be massively appreciated !