> AFAIK, AS is necessary in UNION, at least on some RDBMS, to have the same > columns for all UNION'ed queries. > So in that sense, not strictly syntax sugar. And it's of course valuable > to > give good names to complex expressions. > A good name goes a long way to make "code" (of any sort) more readable and > obvious.
In all cases where AS is used it can be replaced with nothing (removed). There is no distinct purpose for the string as that cannot be served by not having the string as (that is, search and replace all " as " with " ") and you will find that the only meaningful change is that the number of bytes in the statement is less ... JOIN however does have one (and only one) non-sugary use: it is about the only way to specify a join type other than a simple cross (or, where there is a where clause, an equijoin). Most vendors have removed all the various "not included in the spec" methods that used to be used to specify these types of operations. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
