Re: Complex (for me) SQL question

Mike,

My light bulb is on a dimmer switch set about a quarter of the way (not
completely joking there!); I can see the potential, but I need more
practice at it so that it becomes as natural as, say, "ORDER BY".

Thanks again,
- Dan

On Tue, Jan 19, 2016 at 10:06 PM, Mike Jones <mike.jones.sysdev@xxxxxxxxx>
wrote:

Hi Dan,

Book part 2 is a work in progress!

Years ago, I'd initially glossed over LATERAL in the SQL reference manual,
and its significance wasn't readily apparent. Hence, I built a fair amount
of code that should have used it, in alternate, more complex ways.

About 2 years ago, I stumbled across a code example on the internet using
it, and the light bulb went off big time. I've used it hundreds of times
now, and have refactored most of that code that should have used it in the
first place.

Mike

from: Dan <dan27649@xxxxxxxxx>
subject: Re: Complex (for me) SQL question

Mike,

I finally got a chance to try this. Thank you so much! That worked like

a

charm. I would have never figured this out on my own. I've seen LATERAL
discussed a few times here, but could not wrap my head around it. Having
my own real world example helps, but I'll definitely take a close look at
your document. (I noticed it is "Part 1". Do you have other parts
available?)

- Dan

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.