Have any of you worked on converting a SQL query with multiple joins and group by multiple columns
I am trying to convert the following into VB.NET LINQ to dataset
select a.a1, Sum(b.b1 * c.Q) [V_QTY], c.c1, a.a2 , b.b2,d.d1, d.d3, e.e1, c.c2, c.c3
from a
join (select id, a as c1,b as c2, count(num) Q, c as c3, d as c4
from abc
where a=1 and id=3723
group by a, b, c, d) c on a.id= h.id
left join b on b.id = c.id
left join d on d.id= d.id
where c.a= 1
group by select a.a1, c.c1, a.a2 , b.b2,d.d1, d.d3 , c.c2, c.c3
order by c.c1, c.c2, b.b2
Since i have a nested join and i am grouping at both levels it is proving to be a bit awkward. I am also getting familiar with LINQ to dataset. Any help would be appreciated.