tag:blogger.com,1999:blog-497787815177352569.post15622953103771737..comments2024-01-03T08:55:04.827-05:00Comments on SQL Anywhere: The Evolution of a SELECTBreck Carterhttp://www.blogger.com/profile/15975598564711761434noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-497787815177352569.post-34314954013332932442008-03-02T05:55:00.000-05:002008-03-02T05:55:00.000-05:00Ahhhhh yes; what was once confounding is now cryst...Ahhhhh yes; what was once confounding is now crystal clear. From your Step 2 explanation, I learned about derived tables which I have not used before. And I now understand the business rules behind the complex query. I like the 3rd query because my simple mind doesn't have to work so hard to understand it. And best of all, the simple solution produces the right answer! <BR/><BR/>You have a gift for teaching. Thanks for taking the time to do so.Anonymousnoreply@blogger.com