- Local time
- Today, 01:29
- Joined
- Feb 28, 2001
- Messages
- 27,148
Remember that Access cannot tell you anything you didn't tell it first.
Define "TOP" when THE TABLE ITSELF doesn't include prime keys and the selection criteria used for the rank-ordering sort produces a non-unique selection for first-place.
This is one man's opinion, but if another SQL engine answers that question with a single record under those exact circumstances, IT is wrong and Access is right. That is a set theory answer, not a pragmatist's answer.
See any of several threads I have answered regarding "order" of a table when that table does not have a prime key to understand why I answer this way.
I don't always agree 100% with Allen but here he is spot-on.
Define "TOP" when THE TABLE ITSELF doesn't include prime keys and the selection criteria used for the rank-ordering sort produces a non-unique selection for first-place.
This is one man's opinion, but if another SQL engine answers that question with a single record under those exact circumstances, IT is wrong and Access is right. That is a set theory answer, not a pragmatist's answer.
See any of several threads I have answered regarding "order" of a table when that table does not have a prime key to understand why I answer this way.
I don't always agree 100% with Allen but here he is spot-on.
