SQL SERVER

sofiammelo , to be true, I don't understand your post/quession and the provided informations are to less, not of the tables in your ERD matches your post.

Please post table design as DDL, some sample data as DML statement and the expected result.