I'm just wondering if it's possible to query list items from two different lists using Ajax in SharePoint 2010. I know it's possible to use Designer, however, I need this ability outside of Designer (i.e. with C#/jQuery Ajax).
I also know it's possible to query a SharePoint list and add the results to an ArrayList, then query the second SharePoint list and add those results to the same ArrayList. Is there any other way using CamlQuery or SPQuery?