RE: SQL 'Select AS' syntax

I'm still kind of partial to the MR concept. (running for cover)

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
Sent: Friday, January 11, 2008 10:59 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL 'Select AS' syntax

Luis,

Thanks man, you made my day. *Normally* I would embrace newer
technologies and syntax whole heartedly (hey! I am learning Ruby and
Rails right now). But I also don't toss old stuff just because there is
new stuff to replace it. The brain cells I have that survived the 70's
are limited, so I don't use them unless I *have* to. :-)

I knew that the addition of the "join" was "relatively" new and Joe's
post at least gave me no immediate reason to stop using "where"
(although I do agree that "join" is more self documenting and therefore
I AM changing my SQL habits [using a few more brain cells.....]).

Old dogs DO learn new tricks but only if we *need* to....

Pete

Luis Colorado wrote:

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.