select and merge two tables with different granularity..
From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Mon, 01 Dec 2014 13:48:44 +0000
Message-ID: <m5hrjt$72a$1_at_news.albasani.net>
This is a weird one.
Date: Mon, 01 Dec 2014 13:48:44 +0000
Message-ID: <m5hrjt$72a$1_at_news.albasani.net>
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?
-- Everything you read in newspapers is absolutely true, except for the rare story of which you happen to have first-hand knowledge. – Erwin KnollReceived on Mon Dec 01 2014 - 14:48:44 CET