Posted by --CELKO-- on 09/28/22 11:39

>> 'AS' is defined in the ANSI SQL-99 Standard ... an optional keyword in the FROM clause between the object name (table, view, derived table, whatever) and the alias for
it. <<

I like it because it separates things nicely for the eye. In real old
days, leaving out a comma in a FROM clause could accidently create an
alias for a table. I find it funny that people who use the wordy
infixed join syntax for INNER JOINs often skip the AS keyword.

• Next in forum: Re: BACKUP LOG cannot be performed because there is no current database backup
• Prev in forum: Re: one for the SQL experts - dare I say TRICKY SQL!
• Thread view: Re: one for the SQL experts - dare I say TRICKY SQL!

[Reply to this message]