Using join with CAML in SharePoint development 29 March 2011 You can use the SPQuery.Join property in CAML to querying SharePoint lists data.   The each join is represented by a join element (which is child of Joins element). You can use joins to join multiple lists or use multiple joins to the same list….