Mike Yearwood
Toronto, Ontario, Canada
Hi Larry!
Isn't aticles.article a PK?
>Mike,
>Now we have something entirely different than the original. We have a table where article, description and location are different because they come from different rows in the articles table, but we have the same number in InStock for each row in the result set. Because the GROUP BY clause was not applied using the description and location, it only represents the total number of articles globally, not the number associated with the specified description and location.
>
>The result set would be valid but very misleading, IMO.
>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only