subquery in lambda expression

Question

query= from a in table1 join b in table2 on a.id equals b.id                 where b.id in                 (from c in table3                        where c.id1==1 and c.id2==1)                   select new{}).ToArray();
how can i convert this into lambda expressions....
i wrote up to join statement like
        table1.Join(table2, i => i.id, j => j.id,(i, j))
After this how can i implement inner query........

Vulpes · Answer

var query = from a in table1 join b in table2 on a.id equals b.id select new{...}; would translate to: var query = table1.Join(table2 i => i.id j => j.id (i j) => new {...});