> I'm not a manager, and I do have a few "computer skills" (I think), and I > still find JOIN ON much more > readable than the FROM-comma + WHERE alternative. Helps me "thread" the > table join in my head much better. > Definitely helps me "grok" a statement faster, so not syntax sugar to me. > My $0.02. --DD
The main problem with the JOIN/ON syntax is that to a casual reading order is implied (you can see this, for example, in the Microsoft products that litter generated SQL statements with ream upon ream of brackets perhaps in the hope of influencing a query optimizer, but more likely to ensure the result is as unreadable as possible). TO me it is much simpler to understand: SELECT <the data to select> FROM <tables to select from> WHERE <list of conditions> considering that JOIN which is mere sugar is (and ought) to be treated by replacing it with a "," and moving the conditions in the ON clause into the WHERE clause. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
