I want to search data from multiple tables using CAML query.
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
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityCAML doesn't support this. Instead you can look into SPSiteDataQuery or LINQ
If the two lists are related then you can use SPQuery.Join