Create a MS SQL UPDATE statement working with 2 tables

? I need help creating an UPDATE statement that involves at least two tables and will be using a GROUP BY clause. MS SQL 2000 Should not be difficult if someone know what they are doing. ## Deliverables ? HELLO? MS SQL DATABASE coders ? I need help creating a single UPDATE statement. ? I have been poking around with it , but cant get it to work properly. ? It is just 2 tables with Joins and a Group By condition ? If you are very comfortable with? MS SQL? could you please take a look into my request.. My guess is an hour or two? --- only 1 statement needs to be coded Thanks ? * * *This broadcast message was sent to all bidders on Tuesday May 6, 2008 6:02:53 PM: Looking to have this completed by May 7th 3:00 PM EST .... its short notice but its only a single UPDATE statement Thanks