Eva, Back in September there was a similar question. I kept the answers and here were the titles that 4 people here suggested: 1. I found (and continue to find) this website very helpful for writing basic SQL reports: http://www.thundersoftware.com/churchdb/sqltutorial/sql_tutorial.html I tried a few books, but nothing really stood out for me. The books probably have info on some of the more complicated queries, but I was able to create the majority of our necessary reports based on the info from the Thunder Software site. That, and posting an occasional question on this list. The LibLime folks helped me compose a few of the tough ones-thank goodness!! 2. I use the MYSQL in a Nutshell book which has been helpful to me remembering the different sort and join commands. 3. I'm definitely still learning, but in the beginning I interlibrary loaned as many SQL books as possible and then purchased the ones that had helped me (I was starting from scratch) The titles I now have in my office are * Head First SQL * Beginning SQL queries * SQL fundamentals * SQL queries for mere mortals They all give me different things. I also use google searches for various SQL training materials. And I attended KohaCon 2009 and heard at least one of the sessions there. I also use the SQL Reports Library ( http://wiki.koha-community.org/wiki/SQL_Reports_Library <http://wiki.koha-community.org/wiki/SQL_Reports_Library> ) and ask on the mailing lists. ---- 4. There are some presentations from KohaCon last year on SlideShare (http://www.slideshare.net/group/koha-ils) that cover reports. Also, I often refer to the database structure in git (http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob_plain;f=installer/ data/mysql/kohastructure.sql;hb=HEAD) when I need to find out what tables/fields are available for querying. As for learning MySQL, I learned that hands on cause I suck at learning from a book so I can't recommend any good reads - except the MySQL manual which I refer to all the time when I'm trying to remember who to query a specific date format or something like that. From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Eva Radding Sent: Tuesday, November 09, 2010 10:49 AM To: koha@lists.katipo.co.nz Subject: [Koha] Learning SQL Could anyone suggest a good resource (online, print, or in-person) for learning SQL? We would like to have a better understanding so we can more easily create and modify reports. Thank you, Eva Radding Librarian Facing History and Ourselves 16 Hurd Road Brookline, MA 02445 617-735-1680 Eva_Radding@facing.org This email and any information attached to it may be confidential. If you are not the intended recipient, any use or dissemination of the information is prohibited. Please notify the sender that you received the email in error and delete any record of this message. =