I have googled this and seem to only be able to find the same Tutorial here 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.
It's sharepoint 2007, two sites, same collection