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

Regards,

Guy

''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
midrange-l-bounces@m
idrange.com


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].