select r.*, v.* from (select resourceId from resources limit 100) r inner join resourcesattributesvalues v on r.resourceId = v.resourceId
cheers, barneyb On Mon, Nov 16, 2009 at 4:49 PM, Agha Mehdi <aghaime...@gmail.com> wrote: > > I have three tables > > tableA Rresources (resourceID) > tableB Attributes (attributeID, attributeName) > tableC ResourcesAttributesValues (ravID, resourceID, attributeID, value) > > I need to apply MySQL Limit clause to get paginated dataset from row 1 - > 100/101-200/201-300.... I'd like to run a single query to get 1-100... > resources with all of their attributes and values. > > What is the most efficient way to do it? > > Thanks > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4