On Sunday 15 December 2002 17:08, Beauford wrote: > 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.
Automatically - nope. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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