X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B04539FB1F2 for ; Wed, 23 Aug 2006 16:27:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 57482-04 for ; Wed, 23 Aug 2006 19:26:41 +0000 (UTC) X-Greylist: delayed 00:11:33.860729 by SQLgrey- Received: from b217.teamon.com (mailproxy05.teamon.com [64.14.130.34]) by postgresql.org (Postfix) with ESMTP id CC31A9FB24C for ; Wed, 23 Aug 2006 16:26:40 -0300 (ADT) Received: from b217.teamon.com (localhost [127.0.0.1]) by b217.teamon.com (8.11.7/8.11.7) with ESMTP id k7NJF1V16522 for ; Wed, 23 Aug 2006 12:15:01 -0700 MIME-Version: 1.0 From: MHahn@seeandswim.com Subject: All columns from table in a joined query Date: Wed, 23 Aug 2006 15:14:48 -0400 Importance: normal X-Priority: 3 To: Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" Message-ID: <14106936.1156360501724.JavaMail.teamon@b217.teamon.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.777 tagged_above=0 required=5 tests=NO_REAL_NAME, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: **** X-Archive-Number: 200608/168 X-Sequence-Number: 26126 I've been trying to figure out how to do the following: Select schedule.* from schedule join meetingday on schedule.id =3D meetingd= ay.scheduleid where sessionnumber =3D 165 group by schedule.* order by min(= meetingday.date); Is this possible in any way, or do I need to list each field of the schedul= e table to get all of them?