on 11-20-2007 10:04 AM
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...
Hi
SELECT CardCode FROM OCRD WHERE CardCode not in (SELECT CardCode FROM ORDR)
Regards
Vishnu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.