Re: MINUS operator giving different results?

Sorry, I misspoke my previous lower description. What I do want is the rows with an "XBRCOUNT" but without a corresponding "MANCOUNT". The code does return the correct rows when it works. It's just that sometimes it returns 0 rows. I never change the order of that SQL statement. I can cut-and-paste it into the SQL-Plus window and have it randomly give different results on each paste. Also, I can now run just the top part:

 select distinct hcode, storenum, regnum,  transdate from sa_counts where
 batchno = 300 and counttype = 'XBRCOUNT'

and have *it* randomly come back with the correct # of rows, or 0 rows. Is there something wrong with how I'm using distinct?? There are usually 12 copies of each of these rows (with one of the other fields having the changing value), and I only want to know about each combination once. I've never had a problem with distinct in the past. Could it be the version of Oracle at the customer site I'm using this at?

Lisa, lshea_at_earthling.net

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 23 1999 - 12:20:48 CDT