Quoth Petite Abeille <[email protected]>, on 2014-02-03 23:49:14 +0100: > Not directly related to your question, but… why oh why do people > molest their queries by gratuitously and pointlessly aliasing > perfectly good table name to meaningless random one letter codes?!? > Masochism?
Because otherwise you wind up with things like long_table_name.foo, long_table_name.bar, long_table_name.baz, long_table_name.quux, long_table_name.plugh, long_table_name.plover and that buries the changing part in a sea of sameness. The "real" reason I use aliases-always in the first place (but which wouldn't preclude longer aliases) is to semantically distinguish the underlying table from the source as used to construct a particular query; that also makes it more consistent when queries might have multiple sources from the same table. (I know not everyone thinks the same way, so there's a subjective element.) ---> Drake Wilson _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
