Re: Speaking of SQL.....

And some people tend to not understand the difference between a UNION and a
JOIN.

x years ago (I don't remember how many), I didn't even know there was a
UNION, and then I had to figure out the difference between UNION and
UNION ALL :)

JOIN is also interesting -- I'm not sure when I learned you could use a
constant, e.g. flda = 'Y' in the JOIN ON clause. Makes JOIN ON sort of
like a WHERE clause just for the JOIN process.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com