Hi Macro ,
I didnot understood your query . Please clarify the following ..
1) do u have only one qvd and when you are using the where condition, is the data not fetched according to the condition.
2) Do You have more than one QVD and you have to reduce the data in all the other Qvds based on the condition in the year table .
if you want o achieve the second query . you have to use the exists function on the key.