SharePoint SPSiteDataQuery

SPSiteDataQuery is used to Query multiple lists or to read data from all the lists in a site collection.

Get Combined result

Below is the example to query multiple list data sources and get combined information in data table: