Hi, I have two tables, one with peoples names in it and one with data associated to these people. What I need to do is to be able to automatically total certain items in the data table that correspond with a name in the first table and then update the name table..
i.e. This is a crude example, but you get the picture. When I add an item to the data table I want to have it so it automatically gets added to the correct person in the name table. I also have a third table which references these two tables. Can this be done from within MySQL. Names Data Col. 1 Col 2 Col. 1 Col. 2 Fred $2.24 Milk $1.00 Wilma $4.25 Bread $1.24 Barney $1.00 Eggs $2.19 Betty $3.19 Butter $3.25 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
