×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
