SQL was invented in 1974, JOIN was introduced with SQL-92, and probably implemented by IBM on the AS/400 several years later. Is that relatively new? It depends on the beholder.
The point being, though, is that we can't just flag people on a limited assumption.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of GUY_HENZA@xxxxxxxxxxxxxx
Sent: Friday, January 11, 2008 9:35 AM
To: Midrange Systems Technical Discussion
Subject: RE: SQL 'Select AS' syntax
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.
midrange.com
