I'm attempting to create a DVWP that merges 4 lists that share a content type schema but have distinct permissions. The issue I am having is that if a user does not have permissions to one of the lists the DVWP errors out with
Unable to open the specified list.
How would I be able to create such a web part that would allow me to merge these lists showing the user items from only the lists she has access to see?
Edit: To be clear I am not doing a
JOIN like you would in SQL. Each item from each list represents a distinct row in the view. The operation I am performing is more like a
UNION of tables that share a schema. So if each of the 4 lists had only one item the DVWP would display 4 different rows.