title: How do you link Sharepoint Lists across different sites
body: <p>I have googled this and seem to only be able to find the same Tutorial <a href="http://office.microsoft.com/en-us/sharepointdesigner/HA100991441033.aspx" rel="nofollow noreferrer">here</a> or variations thereof.  I have two lists.  Each one is on a different site.  I need to make a list/view joining these two lists.  One site contains basic employee data, (such as department) and the other site contains details about that department that we need to show on a high level overview of employee data.</p>
  
  <p>It's sharepoint 2007, two sites, same collection</p>