1. on new{o.field1, o.field2} equals new {p.field1, p.field2}
2. from m in table1 from n in table2 where m.id==n.id && m.code==n.code select new{...}
