I cant find any good information on how to do this. My situation is this I have a site collection and it has 10 subsites each subsite have the same list with different data, The layout and columns of all these lists are the same. Our current Farm is SharePoint 2007 What i would like to do is create a single list that combines ALL these lists and then display this merged list on a page. is this request can be done? If so how? Thanks in advance

You cannot display data from multiple lists in a single list. Maybe you can create page and show lists in webparts.

Hi, You can use "linked data source" feature to join multiple lists and display data in single dataview. I think that would be the better OOTB option for your requirement. However you can also achieve this using code. Just look below url's for more information about linked data source http://office.microsoft.com/en-us/sharepoint-designer-help/add-a-linked-data-source-HA010115404.aspx http://social.msdn.microsoft.com/forums/en-us/sharepointcustomization/thread/9A575D7C-6E2F-452D-A38D-97092F4071AD http://blah.winsmarts.com/2007-10-performing_joins_between_sharepoint_lists.aspx Hope it could help Off Topic: Duplicate thread. Here is the link. http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/0bb6c174-f2bc-4a57-bf09-a26330dc24e5 Moderator: Please merge both threads. Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"

Hi, You can develop a custom solution using SPSiteDataQuery class and acheive the desired output. Use following links as a reference for your custom solution: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spsitedataquery.aspx http://darrinbishop.com/blog/2007/04/spsitedataquery-for-cross-site-and-cross-list-searches You can also try following OOB solution using Content Query Web Part: http://office.microsoft.com/en-us/sharepoint-designer-help/display-data-from-multiple-lists-with-the-content-query-web-part-HA010174134.aspx Regards, Furqan

Hi, You may use a Content Query Webpart and if these lists are having unique content type, then u can filter it accordingly and show all the items in a single page. Regards, Remya

hi Remya, I have created a new content type & How can i add this content type to my list. Can you please give some steps how to add Thanks

Hi, Please refer the below steps for adding / attaching / Associating the content type with Share point List or Library Browse to the List Settings or Library Settings page for the list or library where you want to use the content type by selecting the List tab or Library tab and the List Settings or Library Settings button. Click the Advanced Settings link. In the Allow Management of Content Types section, select the Yes radio button and then click OK. The Content Types section appears in the Settings page. All lists and libraries have at least one default content type associated with them, so this content type appears. To add another content type to the list or library, click the Add from Existing Site Content Types link. On the Select Content Types page, in the Available Site Content Types section, select the content types you want to add to the list or library and click the Add button to move them to the Content Types to Add list. Click Ok OR Refer the below link http://www.learningsharepoint.com/2010/10/22/create-content-type-in-sharepoint-2010/ Hope it helps Regards,

Hi Waheedswe, Thanks for the steps, By fallowing your steps I have added the content type to all the lists & I have added CQWP but I get "Query has returned no Items" message Below are the steps I fallowed in CQWP Query I have selected Show items from the following site and all sub sites option (selected the required URL) list type:- Custom List content type show items of this content type group :- list content types Show items of this content types:- test content type ( I have selected new content type which i have added in earlier steps Click Apply button 

Hi, Please refer http://www.datasprings.com/resources/articles-information/about-sharepoint-content-query-web-part for more details on CQWP Hope it helps Regards,

Hi, Please refer http://www.datasprings.com/resources/articles-information/about-sharepoint-content-query-web-part for more details on CQWP Hope it helps Regards,