Re: select and merge two tables with different granularity..

From: Lennart Jonsson <erik.lennart.jonsson_at_gmail.com>
Date: Mon, 01 Dec 2014 17:33:00 +0100
Message-ID: <m5i57f$qg2$1_at_dont-email.me>


On 12/01/2014 02:48 PM, The Natural Philosopher wrote:
> This is a weird one.
>
> I have two tables. Table 1 contains 5 minute samples, table 2 contains
> hourly samples.
>
> Let's say I want the last 240 samples of table one merged in time synch
> with the last 20 samples of table 2, with each table 2 set repeated 12
> times..
>
> how can this be done? It looks like some sort of join, but I can't for
> the life of me see where to begin...???
>
> Can one join one row in table two to multiple rows in table one?
>
>

You can extract date + hour info from both timestamps and join with that

/Lennart Received on Mon Dec 01 2014 - 17:33:00 CET

Original text of this message