Description we can create single view by joining many lists in Sharepoint there are two ways of doing this

1.  using SPSiteDataQuery
2. using Linq

Below example is done using the linq joins Step  1: Create three Different list with a common field Like the example Below

      Step  2:

1.  Open New project
2. Create a new visual webpart

 Code in .ascx page Code in .cs page Step  3: Deploy the solution and add the webpart into page in sharepoint.