General information
Category:
Visual FoxExpress
>>As your SQL is something "undefined" due to the group by you should <g> -
>>that is all those Max() (and you can also take Min()).
>
>Sorry, I don't understand the above.
If you have a "group by" all other fields should "reflect" the grouping operation, which is the "tightening" of SQL rules in vfp8 and 9. As for "IIF( NET.Route == NET.Mcl_Rte, " ", NET.Mcl_Rte) as ContrNum" - I overlooked it , thinking it was also a sum operartion like the following statements, which were correct SQL from the start.
What do you expect vfp to show when you have rows with identical ET.operator but differing ET.Date after grouping on ET.operator ?? Any aggregating function will give you a defined result...
regards
thomas
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