Is it possible to show data from two lists in CQWP? I am having this site setup.
Department site -project site 1 -project site 2 -project site 3 - ...
Every site is having a blog. I want to show the newest entries from the department page and only their own project site within every project site. The problem is that I only can chose a list or a top level list within CQWP so I can either only show the project site blog posts or all the blog posts.
Example: In project site 1 I want to see the blog posts from Department and project site 1. In project site 2 I want to see the blog posts from department and project site 2 etc.