Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
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
Required, but never shown