Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Queries give impossible results

Re: Queries give impossible results

From: Will Trash-Spam <mrscopeman_at_hotmail.com>
Date: Thu, 14 Nov 2002 12:02:40 -0000
Message-ID: <ar03nl$l1h$1@pheidippides.axion.bt.co.uk> 






[Snip]



The example you have given is entirely possible as you are attempting to
compare oranges and apples (customer_state and customer_type).



Have you a more concrete example of the data to show the count is wrong?



Have you done a select * instead of a select count(*) and got more than 4
records in your final example?



HTH


Mark Stafford


Sciamus Limited


http://www.sciamus.com
Received on Thu Nov 14 2002 - 06:02:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US