- Local time
- Tomorrow, 02:50
- Joined
- Jan 20, 2009
- Messages
- 12,852
I would have thought a query with Group By on all fields would result in the same results as a DISTINCT.
How to make joined queries editable (1 Viewer)
- Thread starter AlefAelol
- Start date
I would have thought a query with Group By on all fields would result in the same results as a DISTINCT.
- Local time
- Today, 11:50
- Joined
- Feb 28, 2001
- Messages
- 27,175
G:
It was a one-field GROUP BY that resulted from when I was trying to dynamically generate a query string and the aggregated field got left out due to a programmer error. It kind of happened in passing and wasn't intentional. My reaction was, "well, how about that?" followed by fixing the problem and moving on.
It was a one-field GROUP BY that resulted from when I was trying to dynamically generate a query string and the aggregated field got left out due to a programmer error. It kind of happened in passing and wasn't intentional. My reaction was, "well, how about that?" followed by fixing the problem and moving on.
- Local time
- Today, 17:50
- Joined
- Sep 12, 2006
- Messages
- 15,653
non updateable queries are a real pain at times, and hard to deal with directly. We all have to find workarounds for some situations.
eg in some cases, we need a union query for data presentation purposes, but then we have to deal with non updateable records because of the union.
eg in some cases, we need a union query for data presentation purposes, but then we have to deal with non updateable records because of the union.
