I have a select that I use in a Stored Procedure that I can not convert to the LLBL way of retrieving data. Without giving you the select in question, I have something similar that I took from the Northwind Database Stored Procedures.

SELECT ProductName, Total=SUM(Quantity), s.companyname FROM Products P, [Order Details] OD, Orders O, Customers C, suppliers S WHERE C.CustomerID = 'ALFKI' AND C.CustomerID = O.CustomerID AND O.OrderID = OD.OrderID AND OD.ProductID = P.ProductID and p.supplierid = s.supplierid GROUP BY ProductName, s.companyname

How do I can I retreive data from LLBL using that Select Statement?

I've looked in your help file and I do not understand much of it.

Any help would be greatly appreciated. Thank you.

Scott Stalter

You can construct a dynamic list and use that to retrieve the data. See the typed list documentation in the 'using the generated code' section in the documentation for an example. If you need help constructing the dynamic list for this particular example, let me know so I can formulate it for you.

ps: nice nick