List Join operation in SharePoint 2007 / 2010
Approach 1 private static void FetchAllListsDataJoinUsingLinq() { using ( SPSite _spSite = new SPSite ( "<Site Url>" )) { using ( SPWeb web = _spSite.OpenWeb()) { SPList placeList = web.GetList(web.Url + "/lists/TouristPlace" ); SPQuery ospPlaceQuery = new SPQuery (); DataTable dtPlace = placeList.GetItems(ospPlaceQuery).GetDataTable(); SPList cityList = web.GetList(web.Url + "/lists/City" ); ...