Hello

How would I go about doing something similar to below in LLB?

select Website.Id, Website.Name, Count( OrderDetail.OrderDetailId) from Website

    Inner Join [Order] 
    On [Order].SiteId = Website.Id

    Inner Join OrderDetail 
    On OrderDetail.OrderId = [Order].OrderId


Group By Website.Id, Website.Name

A stored procedure is currently being used as we could not work it out using LLB, but we want everything to run with llb if possible because of regen problems.

The count part is the main problem!

Thanks in advance

Bex

Ok please ignore this question... I think I have found the solution. Dynamic Lists...!

I have finally found some info in your documention. For some reason both me and my collegues find it quite difficult to find things in there unless we have a bit of an understanding to start with..