Re: Struggling with the MINUS operator

Hi ! I found the answer. I fact, the right way to write the query is using EXCEPT instead of MINUS sql> SELECT s,o FROM "prop_XXX" EXCEPT SELECT s,o FROM "class_XXX" ; A+ ----- Mail original ----- De: "Leon-Constantin Fopa" À: "Communication channel for MonetDB users" Envoyé: Jeudi 13 Novembre 2014 13:56:45 Objet: Struggling with the MINUS operator Hi ! Here is the query I ran : sql> SELECT s,o FROM "prop_XXX" MINUS SELECT s,o FROM "class_XXX" ; and here is the error I got : syntax error, unexpected SELECT, expecting SCOLON in: "select s,o from "prop_XXX" minus select" Did I missed something ? best regards, _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list