Re: MySQL Limit

I will add that you can achieve the 101-200 by using the OFFSET keyword, eg: SELECT resourceId FROM resources LIMIT 100 OFFSET 100 -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure?

Re: MySQL Limit

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

Re: MySQL Limit

Awesome. thanks On Mon, Nov 16, 2009 at 4:56 PM, Barney Boisvert bboisv...@gmail.comwrote: 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