You got it Larry,
When I looked at the keys there was a foreign key and an index (Haven't the
faintest idea how that happened).
I removed the index and now it is correct!
Thanks,
Bernie
----- Original Message -----
From: "Lawrence Lustig" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Saturday, June 21, 2008 9:02 PM
Subject: [RBASE-L] - RE: select group by problem
<<
Yes John, I just tried that and same result, first date is doubled. But
thanks for looking. Any other ideas?
Do you have a table that you could try a similar test?
Try re-indexing, or removing all indexes on the table, and see what
happens.
--
Larry
