Re: LIMIT result for paging

[Bob johnston]

Thank you Rick!

That does some of the job I was after - so now I have this working code

SELECT * FROM
(
SELECT distinct catalogID
FROM `products`
ORDER BY catalogID
LIMIT 0, 10
) AS T1
JOIN `packages` T2 ON T1.catalogID = T2.catalogID ORDER BY T1.catalogID ASC, T2.packsize ASC

In order to retriewe all of the info from Table `products` is there a more lean way than to add : JOIN `products` T3 ON T2.catalogID = T3.catalogID

That would be my last(?) question