Updates have to be done one table at a time.  Does this help?

Shawn

> I have three tables. 
T> able1 contains the following fields: tel_id, fname, sname, extension, 
d> ept_id, loc_id. 
T> able2 contains: department, dept_id.
T> able3 contains: location, loc_id.

> My select statement is like this:

> SELECT p.fname, p.sname, p.extension, d.department, o.location
F> ROM personnel_list LEFT OUTER JOIN officelocations ON p.loc_id = 
o.loc_id 
L> EFT OUTER JOIN departments ON p.dept_id = d.dept_id

> I would like to add/update these details via a web page. For the add 
page, 
I>  have created a form with blank text boxes for the fname, sname, 
e> xtension fields and list boxes that loop through the departments and 
l> ocations.
M> y problem is how to write an update statement that sets the p.dept_id 
= 
d> .dept_id of the department chosen and the same with the location 
details.

> I can only find select statement examples when working with joined 
tables. 
A> ny help at all would be much appreciated.  Thanks.