How To Perfom grouping in llblgen

Posts   
 
    
Tamer
User
Posts: 19
Joined: 04-Sep-2011
# Posted on: 29-Oct-2012 14:20:13   

Would you please help me perform this T-Sql query using llbl :

SELECT ProductId, ColorId, SizeId,count( ProductId) FROM Instocks group by ProductId, ColorId, SizeId order by ProductId,ColorId, SizeId

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39766
Joined: 17-Aug-2003
# Posted on: 29-Oct-2012 15:17:15   

What have you tried yourself? (and have you looked at the docs which describe grouping in e.g. linq, queryspec and ourlowlevel api?)

Frans Bouma | Lead developer LLBLGen Pro