cancel
Showing results for 
Search instead for 
Did you mean: 

EXCEPT OR MINUS IN QUERY MANAGER

Former Member
0 Kudos

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...

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

SELECT CardCode FROM OCRD WHERE CardCode not in (SELECT CardCode FROM ORDR)

Regards

Vishnu

Former Member
0 Kudos

But if i have 2 fields in select....

SELECT CardCode, ItemName FROM OCRD

EXCEPT

SELECT CardCode, ItemName FROM ORDR

????

With "no it" it can do with 2 fields...

SELECT CardCode, ItemName FROM OCRD WHERE CardCode not in (SELECT CardCode, ItemName FROM ORDR)????????????????

Thanks Vishnu

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks Vishnu.

Answers (0)