I want to search data from multiple tables using CAML query.
1 Answer
CAML doesn't support this. Instead you can look into SPSiteDataQuery or LINQ
If the two lists are related then you can use SPQuery.Join
-
how using SPSiteDataQuery or LINQ it can be solved ?Can yu please provide a querry sample ? My lists are not related. Commented Mar 25, 2015 at 12:06
-
I'm sorry, but why can't you just do a caml query on each, and then abridge the results?– ChrisCommented Mar 25, 2015 at 14:18