General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2000 Server
Hi Frank,
Yes, in the future I think coding will be quite different for some of these statements to do just what you said. As for retrofitting older code, it is less testing to change just that part of the current SQL SELECT.
Thanks for your comment.
Albert Gostick
>Hi Albert,
>
>I think the way it should be handled is that you split the SQL into two different SQL statements. The first one will just have the primary key field and the fields being aggregated, then you join the result of that SQL with the original table to get the other fields that you want.
>
Previous
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