select ACCNO,SERVCO,count(*) from CLAIM
group by ACCNO, SERVCO
having count(*) > 1
returns
ACCNO SERVCO COUNT(*)
61972 C010A 2
68693 C010A 3
81572 Q994A 2
82950 G271A 2
102151 I020A 2
104172 I001A 2
107850 A007A 2
115872 I001A 2
122940 I008A 2
But
select * from CLAIM
where ACCNO = 61972
ACCNO SERVCO
61972 C010A
returns 1 row!
This isn't correct!
|
Failed to recur your issue. I guess that you should have an index on ACCNO. Please try:
REINDEX ALL on CLAIM.
Then you should get the correct result.
|
Reindex all makes no difference.
Bug still exists...
|
|
If possible, zip it and email it to our mailbox.
|
Main
webmaster@hxtt.com