SQL to sumarize same materials in tanks
I would like by SQL query from PI database to make a overview amount (sum) of crude material in crude storages, total amount in tonns by crude name.
We have 7 crude storages, and process a lot of different raw materials. For that reason we want to know how much we have current actual raw materials.
Quantities in tanks
Materials in tanks
Overview in AF:
Example (picture above):
In this case I want to know...
Crude SUM (t)
How to create SQL query for this?