[EMAIL PROTECTED] writes:
> 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);
I think what you're after is
select * from schedule where sessionnumber = 165
order by (select min(meetingday.date) from meetingday
where schedule.id = meetingday.scheduleid);
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
