Forum Discussion
Solved
how to join multiple lists in sharepoint
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
- 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-in-sharepoint-designer
- 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
- 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-in-sharepoint-designer
