db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Biene_Majo@yahoo.de" <Biene_M...@yahoo.de>
Subject Null values with conditions
Date Mon, 07 May 2012 12:14:32 GMT

i have a table with 4 columns:
i now need something like this (in relation to null values):
(A1 AND A2) OR (B1 AND B2)

So that if A1 is not null A2 must not be null and the other way around (so  
if A2 is not null A1 is not allowed to be null).
The same for B1 and B2.
And at least one of the 2 pairs must not be null.

Can someone tell me if this is possible or how?

Thanks for any suggestions / answers

Biene Majo

View raw message