Cassiopeia
Technical User
Hi,
I am wondering if someone here is able to help me in this matter. To the point: I have a table with some "missing" lines and I want to produce an output that always have the same rows (the missing rows should be included). E.g.
As you can see the production for product2 is missing, no production for that product and there is no way to get a line with 0 from the production system. It simply leaves a zero line unreported.
How can I write a query that generates the four lines for every product regardless of if they are in the initial data or not? I have tried to do another table with the four keys and join that but I can't figure out how the query should be written so that all lines were printed repeatedly for the missing lines...
Thanks, Cas
I am wondering if someone here is able to help me in this matter. To the point: I have a table with some "missing" lines and I want to produce an output that always have the same rows (the missing rows should be included). E.g.

As you can see the production for product2 is missing, no production for that product and there is no way to get a line with 0 from the production system. It simply leaves a zero line unreported.
How can I write a query that generates the four lines for every product regardless of if they are in the initial data or not? I have tried to do another table with the four keys and join that but I can't figure out how the query should be written so that all lines were printed repeatedly for the missing lines...
Thanks, Cas