I have master content type
content type Room,
content type Projects,
content type vaccine.
This is how these related
a. Room ID[node] of room content type is entity reference field[field_roomidd] in Projects content type, also in vaccine[field_vroomid].
b. and vaccine id [node of vaccine content type] is entity reference field in content type projects.
Now I want to create view of content type Room and projects and have merged the two views of content type Room and Content type projects.
My requirement is whenever we select room id in filter condition it should show the for that particular room id what's the vaccine created, and projects are exist....I am stuck here please anyone help me on this.