LINQ with joins using sharepoint lists

Here this code is used for using joins in linq uisng sharepoint lists.
here is the code.

 

 

 

 

SPList Firstlist = objWeb.Lists["FirstList"];

SPList Secondlist = objWeb.Lists["Secondlist"];

SPList Thirdlist = objWeb.Lists["ThirdList"];

var customerorders =

from SPListItem first in Firstlist.Items

join SPListItem second in Secondlist.Items on first["Location"] equals second["Location"]

join SPListItem third in Thirdlist.Items on first["Location"] equals third["Location"]

select new

{

Location = Convert.ToString(first["Location"]),

Name = Convert.ToString(first["Name"]),

Address = Convert.ToString(second["Address"]),

Status = Convert.ToString(third["Status"])

};