on ‎2022 Jan 10 3:07 PM
Is it possible to use the intersect and/or except SQL command in the queries stored in the query manager?
It would make writting some queires more easier.
Hi Jonathan,
according to: Link
you can do it like this
SELECT TOP 10 DocEntry FROM ORDR EXCEPT --Union SELECT DocEntry FROM ORDR WHERE DocEntry = 10
regards Lothar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
From what I could see you need to comment the word union as to use the intersect or except command.
Have a look in the link above.
The query-manager always try to use FOR BROWSE (golden Arrows).
It is deactivated when using Union
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.