Hello,

I have a logical expression and want to make it on sql. negation(negation(A) union negation(B))
A means serviceId = 1 & B means serviceId = 6
negation(A) means serviceId<>1
negation(B) means serviceId<>6

but I don't know how to make negation for the whole expression

Thank you beforehand

Zineb

Hello Chris

Basically what I want is A interserction B which is A AND B. But in my case I can not do that because I can't write in the query "select propertyId where serviceId=6 AND serviceId=1". So I thought of an equivalent way to have A intersection with B, which is A AND B. I made 2 negations for A AND B and simplified the expression to negation ( negation(A) union negation(B)). I hope I'm clearer now. What do think?

Zineb

Thank you very much Chris.

'EXISTS' worked for me yesterday but it's no more working today weird!

I used 'IN' instead and it's working fine now

Good luck

Zineb