February 14, 2013 at 8:34 am
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.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy