This is called aggregation, and there are alot of solutions on the market for that. A built in one in moss is the content query web part. But the thing with that one is that it aggregates based on the type of content or metadata of the content, and not based on location (you cant point to two lists and say "just these two"). So if you are happy enough with joining all items that are in all lists of type X, I'd say go with that one.
An example of a good 3rd party aggregator that does do what you want (can connect to any list type) is http://www.kwizcom.com/ProductPage.asp?ProductId=175&ProductsubnodeId=176 A second good one that does it is http://www.omnisys.co.il/main.asp?lngCategoryID=2555 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MacDonald, Mike Sent: Thursday, 28 February 2008 2:42 AM To: listserver@ozMOSS.com Subject: [OzMOSS] Join 2 List into 1 View Does anyone know how to pull information from 2(or more) separate lists and combine that information into one view? For example I have some list items in List A that I want to combine with some items in List B to make one view? I am trying to cut down on the number of lists that I create :) Thank you, Mike ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net