2
Vote

camlex.net join SPlist query

description

Example inner join List in SharePoint in MSDN

http://msdn.microsoft.com/en-us/library/ee539975.aspx

This will give a huge opportunity, but if use lin-q then problem with large list