Using EXCEPT or MINUS clause in the admin ad hoc SQL queries

Stephen Ladek

• January 18, 2023 18:33

Credit (Toni): Hi, is it possible to use an EXCEPT or MINUS clause in the admin ad hoc SQL queries? I'm struggling to get my SQL syntax recognised. Thanks.

0

• 

  Stephen Ladek

  • January 18, 2023 18:34

  Credit (Andy Braden): 

  The site is running MySQL which does not support EXCEPT but may support MINUS. That said, MINUS is run between queries (SELECT A  MINUS SELECT B) and I doubt the tool supports this. It may be more successful to either restructure the primary SELECT to exclude the results or run the larger SELECT and manually remove the undesired results. 

  In anycase, shifting your syntax to MySQL will be the right place to start. 

  0

Please sign in to leave a comment.