I've question about the filtering of results of a query
Image Query.png shows the query
Image Results.pngshows the results of the query
Image Wannahave.png shows how I like to have this
Explanation (this example):
Data from two databases are combined and give result (or NULL if not exists)
Because there are 3 results for Description, Status and Score (PURPLE), the results for Customer, Contract, Component_Value (BLUE) are repeated.
I'dd like the results where Component Value is summed (added together), but only for the 4 original value's and not for all the component values because everything is tripled.
I've tried several things, but no luck.
Can somebody give me a hand?