What would be the lambda equivalent of the following SQL query:
select a.name, s.color from table1 a
left join [table2] s
on a.id = s.id
What would be the lambda equivalent of the following SQL query:
select a.name, s.color from table1 a
left join [table2] s
on a.id = s.id