Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 83328 invoked from network); 5 Jan 2006 19:11:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 Jan 2006 19:11:53 -0000 Received: (qmail 16257 invoked by uid 500); 5 Jan 2006 19:11:51 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 16217 invoked by uid 500); 5 Jan 2006 19:11:50 -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 16206 invoked by uid 99); 5 Jan 2006 19:11:50 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Jan 2006 11:11:50 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [205.158.62.196] (HELO ws6-1.us4.outblaze.com) (205.158.62.196) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 05 Jan 2006 11:11:49 -0800 Received: (qmail 5407 invoked from network); 5 Jan 2006 19:11:27 -0000 Received: from unknown (HELO Danny) (danny.gallagher@gainergroup.com@209.177.255.105) by ws6-1.us4.outblaze.com with SMTP; 5 Jan 2006 19:11:27 -0000 From: "Danny" To: "'Derby Discussion'" Subject: Select records that are not locked? Date: Thu, 5 Jan 2006 14:14:19 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 Thread-Index: AcYSLDpqGyiTGSmnRRSa+0jzeMihpA== X-Virus-Checked: Checked by ClamAV on apache.org Message-Id: <20060105191150.23F9D10FB008@asf.osuosl.org> X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Is there a way on a select statement to select all rows that match the where clause criteria, except for any rows that are locked? Danny Gallagher The Gainer Group 6525 The Corners Parkway Suite 215 Norcross Ga, 30092