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