EXCEPT OR MINUS IN QUERY MANAGER
it Can say me how it do in query manager an query with EXCEPT (MINUS)???
SELECT CardCode FROM OCRD
SELECT CardCode FROM ORDR
Vishnu Kumar Reddy replied
I am not sure wether there is any operator opposite to Union in sql server(i.e. intersects).
But if the number of fields that are to be compared are less then you can use the query as follows
SELECT CardCode,DocEntry FROM ORDR Where CardCode + cast(DocEntry as varchar) not in( SELECT CardCode+ cast(DocEntry as varchar) From OINV)
Hope this will help you