I am trying to join multiple SharePoint list based on Lookup Id (or based on some common column) like how we do in Sql Server, Is there some out of box feature available in SharePoint 2013, if not then how to achieve this.

1 Answer 1


You can use SPD to achieve this, OOB Data View Web Part is what you'll need to configure. Create two datasources, set the link type, and use webpart to show a combination of both. See https://support.office.com/en-us/article/Display-data-from-multiple-sources-in-a-single-Data-View-f9898d20-a5ab-4973-9d16-9f4e4c088ae1

Under Select the link type that best represents the relationship between the selected sources, click Join the contents of the data sources by using the Data Source Details to insert data views and joined subviews.

You have two options: merge or join. You merge data when you have different data sources with the same fields that you want to merge into a single data source. You join data when you have two different data sources that have a field in common that associates one data source with another data source.

Also, http://sympmarc.com/2009/07/24/the-right-way-to-join-two-lists-in-a-dvwp/ might be useful


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.