Awesome. thanks On Mon, Nov 16, 2009 at 4:56 PM, Barney Boisvert <[email protected]>wrote:
> > 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 <[email protected]> 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:328449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
