Does anyone have a recommendation for a good SQL cookbook? I can do some basic selects, updates and deletes but I'm not comfortable with some of the logic involved in joins or the proper use of group by, etc. In addition, though a full exposition on the SQL "language" might be instructive, right now, I need to figure out some queries. For example,
SELECT C_Date,InvoiceNum,AmtPaid FROM cash WHERE Office = "Denver"; Is very straight forward and returns what I expet. So does: SELECT SUM(AmtPaid) FROM cash WHERE Office="Denver"; But, is it possible to combine these two into a single statement so that if I send it all to an outfile, I have a readable report? This is just an example of the kinds of things I'd like to be able to get a handle on through some sort of reference. Thanks, Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
