linq2个对象关联查询的有关问题

linq2个对象关联查询的问题
List<student> list = new List<student>() {
            new student{ Ming="A", Xingbie="N",Xuehao="BL1"},
             new student{ Ming="V", Xingbie="N",Xuehao="BL2"},
            new student{ Ming="B", Xingbie="N",Xuehao="BL3"},
             new student{ Ming="C", Xingbie="N",Xuehao="BL4"},
              new student{ Ming="D", Xingbie="N",Xuehao="BL5"},
               new student{ Ming="E", Xingbie="Y",Xuehao="BL6"},
            };


List<Test> list1 = new List<Test>() {
            new Test{ Fenshu="95", Date="20140718",Xuehao="BL1"},
             new Test{ Fenshu="80", Date="20140716",Xuehao="BL2"},
            new Test{ Fenshu="40", Date="20140713",Xuehao="BL3"},
             new Test{ Fenshu="20", Date="20140718",Xuehao="BL11"},
              new Test{ Fenshu="40", Date="20140716",Xuehao="BL9"},
               new Test{ Fenshu="91", Date="20140718",Xuehao="BL7"},
            };
我想根据Xuehao这个属性关联，把2个list的数据合成在一起，最终想得到的是

        Ming="A", Xingbie="N",Xuehao="BL1",Fenshu="95", Date="20140718"
                Ming="V", Xingbie="N",Xuehao="BL2",Fenshu="80", Date="20140716"
                 Ming="B", Xingbie="N",Xuehao="BL3",Fenshu="40", Date="20140713"

谢了！！！！
 
------解决方案--------------------
var sql = from c in  list 
                  join d in list1
                  on c.Xuehao equals d.Xuehao
                  select new
                  {
                      Ming= c.Ming,
                      Xingbie= c.Xingbie,
                      Xuehao= c.Xuehao,
                      Fenshu= d.Fenshu,
                      Date= d.Date
                  };
------解决方案--------------------

引用:

Quote: 引用:

var sql = from c in  list 
                  join d in list1
                  on c.Xuehao equals d.Xuehao
                  select new
                  {
                      Ming= c.Ming,
                      Xingbie= c.Xingbie,
                      Xuehao= c.Xuehao,
                      Fenshu= d.Fenshu,
                      Date= d.Date
                  };

谢了，如果on后面是多条件的话，on c.Xuehao equals d.Xuehao  &&  c.Ming equals d.Fenshu