By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
account_id | von |
---|---|
1 | 2017-08-01 00:00:00 |
2 | 2017-09-01 00:00:00 |
3 | 2017-10-01 00:00:00 |
account_id | propname |
---|---|
1 | pname1 |
2 | pname1 |
2 | pname2 |
3 | pname1 |
account_id | von | propname |
---|---|---|
1 | 2017-08-01 00:00:00 | pname1 |
2 | 2017-09-01 00:00:00 | pname1 |
2 | 2017-09-01 00:00:00 | pname2 |
3 | 2017-10-01 00:00:00 | pname1 |
account_id | von |
---|---|
3 | 2017-10-01 00:00:00 |