Re: group by

On Wed, 21 Jun 2006 06:56:24 +0000 (UTC), Erland Sommarskog
<esquel@xxxxxxxxxxxxx> wrote:

Jeff Kish (kishjjrjj@xxxxxxxxxxx) writes:
Wow.
I'll have to study up some more on the 'ON' and 'AS' syntax.

The AS is optional and is only for defining an alias for the derived
table. The alias is always mandatory, though.

The ON is part of the newer ANSI syntax for joins which was introduced to
handle left joins, but once you have get used to it, you will use it for
all you joins, because it makes the queries so much clearer.
study study study.. it never ends...
Thanks again. Bonus that it works for sql server 2000 as well, I imagine, the
newer version.
Regards
Jeff Kish
.

Relevant Pages

  • Re: Access doesnt like its own SQL
    ... I guess Access' thing is like the 'AS DerivedTable' syntax ... replace the opening bracket and closing ... your own alias name. ... FROM [SELECT KitItem ...
    (microsoft.public.access.modulesdaovba)
  • Re: E2K7 PF Add email alias
    ... Found the issue to be syntax. ... When using Set-MailPublicFolder I used ... where I should actually have been using the alias. ...
    (microsoft.public.exchange.admin)
  • Re: 9i: Check- constraint Upper(Column)
    ... the brackets are *not* optional. ... So it sounds to me as *alias* is a nice word for a bug. ... the table is referenced in the index definition (but I have ... An error 'missing brackets' is not appropriate here, for the syntax is ...
    (comp.databases.oracle.misc)
  • Re: percentages of top 10 tallies
    ... On Wed, 06 Oct 2004 15:51:16 GMT, Mortar wrote: ... If you use tables in the FROM clause, the syntax is: ... You don't have to provide an alias (in which case you can reference ...
    (microsoft.public.sqlserver.programming)
  • Re: turbo pascal 4.5
    ... i haven't ignored any of you - i tried version 5.5 and the syntax of the ... a mistake as you all say 4.5 didn't exist but it was definitely 4... ... i have loaded the code in and even simple lines, for instance after defining "function colour:byte;" which the compiler passes perfectly it fails in the implementation stage at: ... "Robert Riebisch" wrote in message ...
    (comp.lang.pascal.borland)