Re: [GENERAL] Basic SQL question and kudos

2010-10-05 Thread Dennis Gearon
ger > Subject: Re: [GENERAL] Basic SQL question and kudos > To: "Dennis Gearon" > Cc: pgsql-general@postgresql.org > Date: Tuesday, October 5, 2010, 9:13 PM > On 10/06/2010 12:31 AM, Dennis Gearon > wrote: > > I need to get a join across about 8 tables to only > re

Re: [GENERAL] Basic SQL question and kudos

2010-10-05 Thread Craig Ringer
On 10/06/2010 12:31 AM, Dennis Gearon wrote: I need to get a join across about 8 tables to only return rows for the MAX date in one of the tables for all otherwise identical return results. I am trying to get the most recent edit of normalized records that are composed of elements from all the

[GENERAL] Basic SQL question and kudos

2010-10-05 Thread Dennis Gearon
I need to get a join across about 8 tables to only return rows for the MAX date in one of the tables for all otherwise identical return results. I am trying to get the most recent edit of normalized records that are composed of elements from all the tables. There could be 1 to 100+ successive ed