I can't seem to come up with a solution to the following SQL query, and have a project dependent on a solution. I'd rather not load the whole database and then parse it in the code. With the following Database structure: Field0 Integer Autonumber Field1 Integer Unique Field2 Integer not unique where the starting record would be selected by Field1 (an indexed field of unique values). The ending record required would be the first succeeding record where the value of Field2 is equal to the value of Field2 in the 'starting' record. Field2 is NOT unique and not ordered. The result would be ordered by Field0 (the autonumber field) Is this possible? MySQL Query
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
