Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

EXCEPT OR MINUS IN QUERY MANAGER

Hi,

it Can say me how it do in query manager an query with EXCEPT (MINUS)???

For example:

SELECT CardCode FROM OCRD

EXCEPT

SELECT CardCode FROM ORDR

Thanks...

Former Member
Former Member replied

Hi

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

Regards

Vishnu

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question