Re: one for the SQL experts - dare I say TRICKY SQL!

>> '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. Received on Thu Feb 09 2006 - 21:20:22 CST