Re: [SQL] Aggregate and join problem

2012-03-01 Thread Oliveiros d'Azevedo Cristina
Great to Hear! Best, Oliver - Original Message - From: Swärd Mårten To: Oliveiros d'Azevedo Cristina ; pgsql-sql@postgresql.org Sent: Thursday, March 01, 2012 11:01 AM Subject: Re: [SQL] Aggregate and join problem It worked like a charm! Many thanks for that

Re: [SQL] Aggregate and join problem

2012-03-01 Thread Swärd Mårten
It worked like a charm! Many thanks for that great solution! Best regards, Mårten Från: Oliveiros d'Azevedo Cristina [mailto:oliveiros.crist...@marktest.pt] Skickat: den 1 mars 2012 11:49 Till: Swärd Mårten; pgsql-sql@postgresql.org Ämne: Re: [SQL] Aggregate and join problem Hi, Swärd, A

Re: [SQL] Aggregate and join problem

2012-03-01 Thread Oliveiros d'Azevedo Cristina
Hi, Swärd, As you didn't name your tables' columns I decided to call them col1, col2, etc. I dunno if this will do what you want as it is completely untested code. But, give it a try and see if it works and if it doesn't, tell me the error, and we'll continue from there. You'll have to substitu