Re: limit clause on join results

2006-08-31 Thread Rob Nikander
Yup that works for me too. Thanks. On Aug 31, 2006, at 9:12 AM, Brent Baisley wrote: How about something like this: select * from states, cities, (select id from state limit 2) as stlimit where states.id = cities.state and state.id=stlimit.id I tried it in 4.1 and it works. - Original M

Re: limit clause on join results

2006-08-31 Thread Brent Baisley
How about something like this: select * from states, cities, (select id from state limit 2) as stlimit where states.id = cities.state and state.id=stlimit.id I tried it in 4.1 and it works. - Original Message - From: "Rob Nikander" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 30,