Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <mark.fenbers@noaa.gov>) id 1TSI6k-0007RB-37
	for pgsql-sql@postgresql.org; Sun, 28 Oct 2012 01:56:10 +0000
Received: from na3sys009aog112.obsmtp.com ([74.125.149.207])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <mark.fenbers@noaa.gov>) id 1TSI6d-0003hA-32
	for pgsql-sql@postgresql.org; Sun, 28 Oct 2012 01:56:09 +0000
Received: from mail-qc0-f174.google.com ([209.85.216.174]) (using TLSv1) by
	na3sys009aob112.postini.com ([74.125.148.12]) with SMTP
	ID DSNKUIyQsSCcq/HOreVdM/w7cFlXdz54nndx@postini.com;
	Sat, 27 Oct 2012 18:56:02 PDT
Received: by mail-qc0-f174.google.com with SMTP id o22so2042075qcr.19
	for <pgsql-sql@postgresql.org>; Sat, 27 Oct 2012 18:56:01 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:x-gm-message-state;
	bh=SIGZYQ58B/Zicgvlx+mDAkGYQMXAuSKLp2zOy05X8/I=;
	b=mQuj+SdOhoOIoTfuFfLsb/uS+aIpCtGgTfUIr+8fBTcyDdzngN1vELKpB0hovSR6YD
	yShQG4Ekts0DL9mVNhtjxmC1mpP/rao0lcktG2QL7ie2er1ZozHj7OWO1mzTnvUaNvZH
	FqCl4I3FMBLtjjCvg9IASD+tH+3kwseRaDt1SXaG500Ro28Ztw5R9KE+wJ1XZORp8f/L
	YZhfGOFGEQuTj2X2s/IY4lDr+fLlCeSaFNLqMY9sLBylZqrDH48jRT9GcBxxhetujh28
	/7M7dPtngYmGsTeDgKb0Z5aHOi7z6UPUhxui9tgt/ryULyuR2b2X4L7hryuQQp8AEmpn
	tGrg==
Received: by 10.49.127.115 with SMTP id nf19mr18263657qeb.36.1351389360903;
	Sat, 27 Oct 2012 18:56:00 -0700 (PDT)
Received: from [198.206.42.50] (rrcs-24-172-201-241.central.biz.rr.com.
	[24.172.201.241])
	by mx.google.com with ESMTPS id b5sm3617048qao.13.2012.10.27.18.55.59
	(version=TLSv1/SSLv3 cipher=OTHER);
	Sat, 27 Oct 2012 18:56:00 -0700 (PDT)
Message-ID: <508C90B5.3060308@noaa.gov>
Date: Sat, 27 Oct 2012 21:56:05 -0400
From: Mark Fenbers <mark.fenbers@noaa.gov>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
	rv:16.0) Gecko/20121010 Thunderbird/16.0.1
MIME-Version: 1.0
To: Scott Marlowe <scott.marlowe@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: complex query
References: <508C75D1.2070906@noaa.gov>
	<CAOR=d=17g1mnKENbJDTiKb-7_JptrdSE43Lz=WF+XmNL9R1akw@mail.gmail.com>
In-Reply-To: 
 <CAOR=d=17g1mnKENbJDTiKb-7_JptrdSE43Lz=WF+XmNL9R1akw@mail.gmail.com>
Content-Type: multipart/mixed; boundary="------------030209020201040806020004"
X-Gm-Message-State: 
 ALoCoQkxmG2O/wX28qQz8bM6YiAyT60JTIDIAA1v3zsyauV543o8WlxNIEmhG7wWalRUVjFiK1OL
X-Pg-Spam-Score: -4.2 (----)
X-Archive-Number: 201210/51
X-Sequence-Number: 36922

This is a multi-part message in MIME format.
--------------030209020201040806020004
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFCC" text="#000000">
    <blockquote
cite="mid:CAOR=d=17g1mnKENbJDTiKb-7_JptrdSE43Lz=WF+XmNL9R1akw@mail.gmail.com"
      type="cite">
      <pre wrap="">
I'd do somethings like:

select * from (
    select id, sum(col1), sum(col2) from tablename group by yada
   ) as a [full, left, right, outer] join (
    select id, sum(col3), sum(col4) from tablename group by bada
    ) as b
on (a.id=b.id);

and choose the join type as appropriate.</pre>
    </blockquote>
    Thanks!&nbsp; Your idea worked like a champ!<br>
    Mark<br>
    <br>
  </body>
</html>

--------------030209020201040806020004
Content-Type: text/x-vcard; charset=utf-8;
 name="mark_fenbers.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="mark_fenbers.vcf"

begin:vcard
fn:Mark Fenbers
n:Fenbers;Mark
org:Ohio River Forecast Center;Hydrometeorological Analysis & Support Unit
adr:1901 South OH-134;;National Weather Service;Wilmington;OH;45177-9708;USA
email;internet:Mark.Fenbers@noaa.gov
title:Senior Meteorologist
tel;work:937-383-0430
tel;fax:937-383-0033
url:weather.gov/ohrfc
version:2.1
end:vcard


--------------030209020201040806020004--