Top positive review
Most Valuable SQL Query Book I Have Read
Reviewed in the United States on January 22, 2014
I have read 4 different books on this, but this one is the best. Here are the 4:
"Access 2007 Pure SQL" (Pindar)
"SQL Queries for Mere Mortals" (Viescas & Hernandez)
"Beginning Microsoft SQL Server 2012 Programming" (Atkinson & Vieira)
"Professional Microsoft SQL Server 2008 Programming" (Vieira)
The 1st book is more limited to Access, however, for rank beginners to understand simple queries, this was a good book. If you need help with more complex queries, though, you'll need something else.
The 2nd book is totally geared towards queries and has examples and discussion from simple to very complex. I found it to be very understandable and refer back to it whenever I'm stuck.
The 3rd book is good for a beginner to SQL Server. It is geared to overall SQL Server, though, so queries is only a part of it.
The 4th book, like the 3rd, takes an overall view, with more in-depth topics. However, its devotion to queries is rather limited. If your concern is query performance, though, Vieira does spend adequate time, here.
My most recent SQL query issue was answered most easily by "SQL Queries for Mere Mortals": I needed a LEFT JOIN using a SubQuery. To me, this is my SQL Query bible. That being said, it is not perfect. At times, it gets needlessly verbose. Also, since it covers SQL queries for Access, DB2, MS SQL Server, MySQL, Oracle and Ingres, it sticks generally to the SQL standard and just comments about not all DBs support everything. Sometimes they give specifics about which ones do / do not support particular keywords or operators...and sometimes they don't. for example, on page 301: "Be aware that some database systems do not yet support USING." It would be very helpful if they had a table in the Appendix that showed such keywords (on one axis) and the database systems (on the other axis) and very simply showed which ones support these keywords--they don't have such a table. Despite these shortcomings, I still gave it 5 stars--it is just that valuable to me.