score:3

Accepted answer
var results = from t1 in table1
              let t2 = (from t in table2 select t)
              where t1.date == t2.date
              select new MyModel {
                TheDate = t1.date == null ? t2.date : t1.date,
                Data1 = t1.data1,
                Data2 = t2.data2,
                Data3 = t2.data3
              };

Related Articles