title: SharePoint list view created from multiple lists on the same site
body: <p>I want to create a SharePoint list/ view comprimised of multiple columns from different lists on the same site.</p>
  
  <p>Do I have to create a separate list for this or can I simply create a view? The reason why I am doing this is to be able to use reporting webparts that require a <strong>single</strong> list as input.</p>