From derby-user-return-1295-apmail-db-derby-user-archive=db.apache.org@db.apache.org Tue May 17 19:05:54 2005 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 56890 invoked from network); 17 May 2005 19:05:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 17 May 2005 19:05:54 -0000 Received: (qmail 74124 invoked by uid 500); 17 May 2005 15:38:59 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 74045 invoked by uid 500); 17 May 2005 15:38:55 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 73977 invoked by uid 99); 17 May 2005 15:38:54 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FORGED_RCVD_HELO,SPF_HELO_PASS X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from adsl-64-174-44-82.dsl.snfc21.pacbell.net (HELO itsy.pauljlucas.org) (64.174.44.82) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 17 May 2005 08:38:53 -0700 Received: from itsy.pauljlucas.org (SouthBay@localhost.localdomain [127.0.0.1]) by itsy.pauljlucas.org (8.13.4/8.13.4/Debian-1) with ESMTP id j4HFcaD4000868 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Tue, 17 May 2005 08:38:36 -0700 Received: from localhost (pjl@localhost) by itsy.pauljlucas.org (8.13.4/8.13.3/Submit) with ESMTP id j4HFcawx000863 for ; Tue, 17 May 2005 08:38:36 -0700 X-Authentication-Warning: itsy.pauljlucas.org: pjl owned process doing -bs Date: Tue, 17 May 2005 08:38:36 -0700 (PDT) From: "Paul J. Lucas" X-X-Sender: pjl@itsy.pauljlucas.org To: Derby Discussion Subject: Re: Sorting with sub-select In-Reply-To: <4289077C.2010207@sbcglobal.net> Message-ID: References: <4289077C.2010207@sbcglobal.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On Mon, 16 May 2005, Jack Klebanoff wrote: > Use an ORDER BY clause, e.g. But then all the metadata for a single image isn't grouped together. - Paul