sharepoint2010 list联合查询--（未整理）

 遇到多个list联合查询的问题，where条件来自多个表
遇到多个list联合查询的问题，需要用CAML做到类似于SQL中的：

 select A.*,A.CityID,B.CityNAME from tableA A left join tableB B on A.CityID=B.ID where tableA .Name=xxx or tableB.CityName=xxx  or....

先说SPQuery 和SPSiteDataQuery的区别

　MOSS 关于SPQuery 的用法，是关于列表的查询

 SPWeb web = (new SPSite(" http://moss/sites/hello)).OpenWeb (); 
SPList list = web.Lists["test"]; 
SPQuery query = new SPQuery(); 
query.Query = " 4 "; 
SPListItemCollection items = list.GetItems(query); 
foreach(SPListItem item in items) 
Console.WriteLine(item.DisplayName); 
　　　　SPSiteDataQuery的是查询整个Site的范围比SPQuery。
SPWeb web = (new SPSite(" http://moss/sites/hello)).OpenWeb (); 
SPSiteDataQuery query = new SPSiteDataQuery(); 
query.Query = " 4 "; 
query.Lists = " 
"; 
query.Webs = " "; 
query.ViewFields = " 
"; 
DataTable dt = web.GetSiteData(query); 
Console.WriteLine(dt.Rows.Count); 

SPSiteDataQuery siteQuery = new SPSiteDataQuery();
                                 siteQuery.Webs = "<Webs Scope=\"SiteCollection\" />";
                                 siteQuery.Lists = string.Format("<Lists><List ID='{0}' /><List ID='{1}' /&g