Account table has a field state and a field id. Transaction table has fields id, user_id, amount, added
Id is the PK in the account table, related to the user_id in the transaction table. I need to get a sum of the amount column for all users in state of TX in the year of 2003. Tried a few ways, cant seem to get this one. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]