Fist table:

```
Value Time
4     2014.12.2 14:00:00
5     2014.12.2 14:01:00
7     2014.12.2 14:02:00
4     2014.12.2 14:03:00
```

second table:

```
Value Time
10    2014.12.2 14:00:00
5     2014.12.2 14:01:00
3     2014.12.2 14:03:00
12    2014.12.2 14:05:00
```

how to do so:

```
Value, Value2 Time
4      10     2014.12.2 14:00:00
5      5      2014.12.2 14:01:00
7      3      2014.12.2 14:02:00
4      -      2014.12.2 14:03:00
-      12     2014.12.2 14:05:00
```

I have implemented the code:

```
SELECT t1.value as Value,
                t2.value as Value2,
                COALESCE(t1.Time, t2.Time) AS Time
           FROM t1
FULL OUTER JOIN t2 USING (Time)

```

It so:

```
Value, Value2 Time
-      20     2014.12.4 2:25:58
20     -      2014.12.4 2:25:58
20    212     2014.12.4 2:26:09
-     212     2014.12.4 2:26:19
-      12     2014.12.4 2:26:20
```

how to do so here:

```
Value, Value2 Time
20    20      2014.12.4 2:25:58
20    212     2014.12.4 2:25:09
-     212     2014.12.4 2:26:19
-     12      2014.12.4 2:26:20
```