All columns from table in a joined query

From: MHahn(at)seeandswim(dot)com
To: <pgsql-sql(at)postgresql(dot)org>
Subject: All columns from table in a joined query
Date: 2006-08-23 19:14:48
Message-ID: 14106936.1156360501724.JavaMail.teamon@b217.teamon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I've been trying to figure out how to do the following:

Select schedule.* from schedule join meetingday on schedule.id = meetingday.scheduleid where sessionnumber = 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 schedule table to get all of them?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Petersen 2006-08-23 19:29:12 Deleting Functions
Previous Message Scott Marlowe 2006-08-23 18:28:36 Re: SQL92 compliance