[KLUG Members] easy DB

[Adam Tauno Williams]

> 2. Writing the query myself is faster for me.  I know EXACTLY what I
> want, I know EXACTLY what I am going to get.  Simple queries and
> complex queries are both easy to write once you have become well
> rehearsed with SQL.  If you look at the SQL some of the query writers
> generate they look like dog cr#p.  I get headaches trying to sort out
> the un-needed parens and extra stuff.

In part this depends alot on how well you know the schema of of your database. 
Since I spend all day in one I know all the major table & field names,  I can
see how working with a foriegn one might make using a GUI easier.

> 3. You don't need to say "JOIN tbl2 ON tbl1.key=tbl2.key".  In MySQL if
> both key names are the same you can use the "JOIN tbl2 USING keyname"

Your statement is valid, but 'In MySQL' is not relevant.

SQL92 -> "tableA [join type] JOIN tableB USING (column, column, ....)"

Every RDBMS should support your syntax.  However the values supported as '[join
type]' may vary.  SQL92 defines: CROSS, INNER, LEFT, RIGHT, FULL, and UNION.