[MonetDB-users] Insert query into second database

Hello, I have two databases "mydb" and "test". I want to get a sub-set of values from 'mydb' into 'test'. My code: "insert into test.result select sum(chargfeeprepaid) from mydb.data where callingpartyno = 200 union select sum(chargefeeprepaid) from mydb.sms where callingpartyno = 300;" This works fine in MySQL...but in Monetdb i get the error: INSERT INTO: no such scheme 'test'. Where did i go wrong and what is the correct syntax to do this in monetdb? Greetings Seleen -- View this message in context: http://old.nabble.com/Insert-query-into-second-database-tp32667556p32667556.... Sent from the monetdb-users mailing list archive at Nabble.com.