Re: getting a subset from a database of records

2015-12-30 Thread Rick Hillegas
On 12/30/15 5:29 PM, Bob M wrote: Hi My database records contain a field A which either has a numeric entry or is I wish to pull out a subset where the value of various fields are set by me. That part is working OK. But, in addition, I only want those records where the above field A is not

Re: getting a subset from a database of records

2015-12-30 Thread Bob M
Thanks Rick oh, so obvious :) Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/getting-a-subset-from-a-database-of-records-tp145247p145249.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

getting a subset from a database of records

2015-12-30 Thread Bob M
Hi My database records contain a field A which either has a numeric entry or is I wish to pull out a subset where the value of various fields are set by me. That part is working OK. But, in addition, I only want those records where the above field A is not to be counted What do I incorporate