I have one site collection that is
RootSite. Two sub sites that are
subSite1 has list
EMP_info with columns
subSite2 has list
DEPT_info with columns
I want to show list
RootSite in a Visual Web Part.
I implemented it by using
SPSiteDataQuery, writing two separate queries. But how is it possible to write it using a single query?
If there are 1000 sub sites and 1000 lists with same column name, then how it is possible to get that 1000 list using a single query?