title: Combining different lists data and showing it in a webpart
body: <p>let me explain my current situation</p>
  
  <p>i have a SharePoint site lets say it is MAIN, and a subsite lets call it SUBMAIN</p>
  
  <p>in MAIN i have a list called "a" and in subMAIN i have a list called "b" </p>
  
  <p>both lists have the exact same columns, </p>
  
  <p>i need to show the content of both lists (ordered by modified date for example) in one webpart in the main page i know it is possible some how but couldnt get to it.</p>
  
  <p>currently i am showing only the content of list "a" in a content query webpart (i have changed the way it display and added to it horizontal merquee) so it will be nice if somehow i can add contents of list"b" also to the same content query webpart (but if it is not possible in content query webpart its ok, at least let me know what other options do i have)</p>
  
  <p>your help is appreciated</p>