--- Patrick Bierans <[EMAIL PROTECTED]> wrote:
> > SELECT cust_id, cust_name
> > FROM (SELECT cust_id, cust_name, ROWNUM rn
> > FROM ky_cust
> > WHERE cust_id > 10) inn
> > WHERE inn.rn = 1
>
> Note: SubSelects are supported by MySQL version 4.1 +
Despite the fact that I'm using Oracle (;-)) I made the above work.
Thanks for the assist!
-Bob
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
