SOLVED

how to join multiple lists in sharepoint

Brass Contributor

Hi

 

I am new to sharepoint. I would like to know how I can join multiple lists or libraries in sharepoint 2013 like other products Microsoft Access or Sq. Query.

 

very appreciate for any guidance

 

Regards

Masoud

3 Replies
Ouch. If you really on SharePoint 2013 and a bad open better than none… I think if you open SharePoint Designer, there is an option under data connections. Note this is totally unsupported in 2022.

Thanks.@PamDeGraffenreid 

now I am working on sharepoint 2013 and this is the only choice for me.

can you send a link address about how i have to use this in sharepoint designer and more explain and guide.

 

Regards

Masoud

best response confirmed by Masoud1313 (Brass Contributor)
Solution
When you set up a linked data connection - a wizard will pop up that asks if you want to do a merge or a join. You want to join, it should be on the right side. Here are a couple of articles I found. Good luck!

https://www.ilikesharepoint.de/2013/12/sharepoint-2013-using-linked-data-sources-for-listview/

https://sharepoint.stackexchange.com/questions/188099/join-two-lists-in-sharepoint-using-linked-view...
1 best response

Accepted Solutions
best response confirmed by Masoud1313 (Brass Contributor)
Solution
When you set up a linked data connection - a wizard will pop up that asks if you want to do a merge or a join. You want to join, it should be on the right side. Here are a couple of articles I found. Good luck!

https://www.ilikesharepoint.de/2013/12/sharepoint-2013-using-linked-data-sources-for-listview/

https://sharepoint.stackexchange.com/questions/188099/join-two-lists-in-sharepoint-using-linked-view...

View solution in original post