From derby-user-return-14330-apmail-db-derby-user-archive=db.apache.org@db.apache.org Mon May 7 12:15:04 2012 Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 04CB7984F for ; Mon, 7 May 2012 12:15:04 +0000 (UTC) Received: (qmail 15620 invoked by uid 500); 7 May 2012 12:15:03 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 15586 invoked by uid 500); 7 May 2012 12:15:03 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 15575 invoked by uid 99); 7 May 2012 12:15:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 May 2012 12:15:03 +0000 X-ASF-Spam-Status: No, hits=0.7 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [217.146.183.192] (HELO nm18.bullet.mail.ukl.yahoo.com) (217.146.183.192) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 07 May 2012 12:14:56 +0000 Received: from [217.146.183.215] by nm18.bullet.mail.ukl.yahoo.com with NNFMP; 07 May 2012 12:14:35 -0000 Received: from [77.238.184.78] by tm8.bullet.mail.ukl.yahoo.com with NNFMP; 07 May 2012 12:14:35 -0000 Received: from [127.0.0.1] by smtp147.mail.ukl.yahoo.com with NNFMP; 07 May 2012 12:14:35 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.de; s=s1024; t=1336392875; bh=zagoeetbDRU4aNMQpc2l6hkSreZ9Z4WsUw7WtYCQRWE=; h=X-Yahoo-Newman-Id:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:Content-Type:Date:To:Subject:MIME-Version:Content-Transfer-Encoding:From:Message-ID:User-Agent; b=UsxkFEO0JxhQuWw/EVv4tHZDlQ1vuareeyR6L48s2N19rFOcCC1kqQTYiUXaNbuin6oRiTBC3BYAWVs3am3G+hqchxz7Cu0lDhQV7yF+OhHUAUsM0CMkYMZdMsaD07CATB8zTTjWspel/EFVGd8NhpHbCqziJcvIPEdx6Hv4roE= X-Yahoo-Newman-Id: 170914.51446.bm@smtp147.mail.ukl.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: W8pYF8YVM1ktEUQc8WBMoiAfeevQsBll37F0DhZmfz_FuPD bqmZ9xpuKmZ1gz4dLzfsBFIpmKn5LAa3bnlmc4t4ublxAKbrO8e9w3rDCilB YrKhUUniWkskiBL3QNYBAxTZcrXNsJVuEczVZzDrgtdJwdH4IYsa34aQ8kN9 tD8nMdsIXcHWwEaAITsjDN42jKjDDfK1UkjVtEXaFFuqi9cCtZBg_96EIHV2 TCuijLGBzKXnyZ9tJknL4zpXw6WOiKoubaO8heiutuF6mPoKrVozYHORhqh7 9oiln928jzY_1fPd07kzkOAZWE26cWvzH_Zv3S00GM4OkbQstN7AY6p8EbHM G1cys3KBgZ3G73EEAfQzfDEwW X-Yahoo-SMTP: BJF1uo.swBDcHmhjnI3Mp0k6ndc.PgE- Received: from pawel-pc (Biene_Majo@94.220.218.66 with login) by smtp147.mail.ukl.yahoo.com with SMTP; 07 May 2012 12:14:34 +0000 GMT Content-Type: text/plain; charset=iso-8859-15; format=flowed; delsp=yes Date: Mon, 07 May 2012 14:14:32 +0200 To: "derby-user@db.apache.org" Subject: Null values with conditions MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: "Biene_Majo@yahoo.de" Message-ID: User-Agent: Opera Mail/11.62 (Win32) X-Virus-Checked: Checked by ClamAV on apache.org Hi, i have a table with 4 columns: A1 A2 B1 B2 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