Re: Merging timeseries in postgres

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Jul 14, 2016 at 8:18 AM, Nick Babadzhanian <nb@xxxxxxxx> wrote:

Whats exactly is wrong with the following query?

select
        dx date,
        nx,
        nx1
    from
        test t
            join test1 t1 on t.dx=t1.dx1
;

​Please don't top-post.

test t join test1 t1 -- this is the default inner join, your query returns no records for the given data.

David J.

​