Is there any possibility to join Sharepoint 2010 internal data sources (like lists) in "out-of-the-box" Sharepoint 2010 tools or SPD without using programming tools?
"Join" and "merge" queries exist creating "Linked Data Source" (by "Link Data Source Wizard") but when I try to use it for lists and go yo "Query" tab, all options are disabled and it is written there:
- "Query options are availablefor Database Connections only"
And if it is impossible to configure joins, then why does it permit to add lists to a linked Data Source?
And what does it mean?
Should I prefer external data sources over internal ones?
Why cannot list joins and merges be configured?