Re: Help with join syntax sought - Mailing list pgsql-general

From James B. Byrne
Subject Re: Help with join syntax sought
Date
Msg-id 54321.216.185.71.24.1242767391.squirrel@webmail.harte-lyne.ca
Whole thread Raw
In response to Re: Help with join syntax sought  (Andy Colson <andy@squeakycode.net>)
Responses Re: Help with join syntax sought  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
On Tue, May 19, 2009 16:41, Andy Colson wrote:

> If your query above is getting you mostly what you want, just use it
> as a derived table.
>

I lack the experience to understand what this means.

If, as you suggest, I use a subquery as the expression to the main
SELECT and for it I use the syntax that returns every distinct
combination of base, quote, timestamp, and type, then what?

Unless I am missing something then I still have too many rows for
those currencies with more than one type.

--
***          E-Mail is NOT a SECURE channel          ***
James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3


pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Help with join syntax sought
Next
From: "James B. Byrne"
Date:
Subject: Re: Help with join syntax sought