I hate to burst your bubble old man but "the 80's" is NOT "relatively new".



''There is nothing so useless as doing efficiently that which
should not be done at all.'' - Peter F. Drucker

"Luis Colorado"
<LuisC@fmssolutions. To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
com> cc:
Sent by: Subject: RE: SQL 'Select AS' syntax

01/11/2008 09:27 AM
Please respond to
Midrange Systems
Technical Discussion

Rob wrote:

But, me, I'd avoid the where clause for a couple of reasons. One, it flags
you as someone who only learned SQL by taking Query/400 and doing a
RTVQMQRY against it. Two, you can do stuff with JOIN that Query/400
explains to you, but warns you with ANZQMQRY that they won't export
correctly with RTVQMQRY - like left outer join, (or as Query calls it:

FYI... the "JOIN" keyword is a relatively new guy. When I learned DB2 SQL
queries from the classic Date's database book in the 80's, "JOIN" was not
there yet.

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.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].