I’m a beginner in making Query’s (and SQL).
In the Example file I have a Query. In the last Column I made a query to count the products per Customer/Storenr. Now I want different columns and count the quantity of Product A, B and C.
Also I want to show all stores, even if don’t have any products. I need an OUTER JOIN I think. When I replace INNER JOIN with OUTER JOIN in the SQL-View, it's not working.
I think this is a basic question, but can’t find the right solution. I played around with the criteria, but no luck.