mapi:monetdb://localhost:50001/slave1
 mapi:monetdb://localhost:50002/slave2
 mapi:monetdb://localhost:50003/master

 -- all of them
 DROP SCHEMA IF EXISTS foo;
 CREATE SCHEMA foo;
 SET SCHEMA foo;
 
 CREATE TABLE data_local (origin CHAR(5), dest CHAR(5));
 INSERT INTO data_local
 VALUES
 	-- flights from foo to bar and vice versa
 	('foo', 'bar'), ('bar', 'foo'),
 	('foo', 'bar'),
 	-- but one way only from foo to baz
 	('foo', 'baz');
 

 -- master
 CREATE REMOTE TABLE data_slave1 (LIKE data_local)
 ON 'mapi:monetdb://localhost:50001/slave1';
 
 CREATE REMOTE TABLE data_slave2 (LIKE data_local)
 ON 'mapi:monetdb://localhost:50002/slave2';
 
 CREATE MERGE TABLE data_1merged (LIKE data_local);
 ALTER TABLE data_1merged ADD TABLE data_slave1;
 
 CREATE MERGE TABLE data_2merged (LIKE data_local);
 ALTER TABLE data_2merged ADD TABLE data_slave1;
 ALTER TABLE data_2merged ADD TABLE data_slave2;


 -- slave1
 CREATE TABLE data_slave1 AS SELECT * FROM data_local WITH DATA;
 
 
 -- slave2
 CREATE TABLE data_slave2 AS SELECT * FROM data_local WITH DATA;

 -- inc
 SELECT origin, count(*) as incoming
 FROM data_2merged
 WHERE dest = 'foo'
 GROUP BY origin
 ;
 
 -- outg
 SELECT dest, count(*) as outgoing
 FROM data_2merged
 WHERE origin = 'foo'
 GROUP BY dest
 ;
 
 WITH inc AS (
     SELECT origin, count(*) as incoming
     FROM data_2merged
     WHERE dest = 'foo'
     GROUP BY origin
 ),
 outg AS (
     SELECT dest, count(*) as outgoing
     FROM data_2merged
     WHERE origin = 'foo'
     GROUP BY dest
 )
 SELECT *
 FROM inc FULL OUTER JOIN outg ON inc.origin = outg.dest
 ;

 +--------+----------+
 | origin | incoming |
 +========+==========+
 | bar    |        2 |
 +--------+----------+
 1 tuple
 +-------+----------+
 | dest  | outgoing |
 +=======+==========+
 | bar   |        4 |
 | baz   |        2 |
 +-------+----------+
 2 tuples
 +--------+----------+-------+----------+
 | origin | incoming | dest  | outgoing |
 +========+==========+=======+==========+
 | bar    |        2 | bar   |        4 |
 | null   |     null | baz   |        2 |
 +--------+----------+-------+----------+

 | null   |        0 | baz   |        2 |

fixed bug #6459
and bug #6456