Excellent article Helen, pleased to see you also answered the why not use subqueries instead. I love using them as you mentioned in your post to keep things readable and reusable in the query.
Thanks Mark. They've been a hot topic around the office recently so thought they deserved a bit of love and a post to support my case.
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Excellent article Helen, pleased to see you also answered the why not use subqueries instead. I love using them as you mentioned in your post to keep things readable and reusable in the query.
Thanks Mark. They've been a hot topic around the office recently so thought they deserved a bit of love and a post to support my case.