Re: Merging timeseries in postgres

Whats exactly is wrong with the following query?

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