Re: SQL 'Select AS' syntax

[Pete Helgren <Pete@xxxxxxxxxx>]

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