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,
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" leon-constantin.fopa@imag.fr À: "Communication channel for MonetDB users" users-list@monetdb.org 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
participants (1)
-
Leon-Constantin Fopa