Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2003 Server
Hi Albert
>Ah yes...just looked at the results and realized that myself (now)...HAVING does not apply to all 3 - so looks like I have to do a subsequent query on the first results set if I want to cut down on typing. Thanks!
Cutting down on typing is not the requirement. Cutting down on performance and maintenance is the requirement. If anything more typing to make it more readable is better in the long run.
Copy and paste is your friend, as long as you are not using it to reuse code blocks.
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